MS Excel 2002 formulas
 

I am constructing a Sales Order Form and I keep getting an error message that
I have too many arguments in the formula. The result that I am looking for
is: In column E the user will enter a value; IF the value in column E is <=
37, then multiply the value in column B by 14.3; IF the value in column E is
37 and <= 43, then multiply the value in column B by 15.05; IF the value in
column E is 43 and <=49, then mulitiply the value in column B by 15.8; IF
the value in column E is greater than 49, then return "Error - Check O-T-O".
Any help would be appreciated.

MS Excel 2002 formulas
 

So what's your formula?

Consider using VLOOKUP. A tutorial can be found he

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"eloughrey" <u39580@uwe wrote in message news:7c24c8c1cb749@uwe...
|I am constructing a Sales Order Form and I keep getting an error message that
| I have too many arguments in the formula. The result that I am looking for
| is: In column E the user will enter a value; IF the value in column E is <=
| 37, then multiply the value in column B by 14.3; IF the value in column E is
| 37 and <= 43, then multiply the value in column B by 15.05; IF the value in
| column E is 43 and <=49, then mulitiply the value in column B by 15.8; IF
| the value in column E is greater than 49, then return "Error - Check O-T-O".
| Any help would be appreciated.
|

MS Excel 2002 formulas
 

Try this:

=IF(E149,"Error - Check O-T-O",IF(E143,15.8,IF(E137,15.05,14.3)*B1))

--
Biff
Microsoft Excel MVP


"eloughrey" <u39580@uwe wrote in message news:7c24c8c1cb749@uwe...
I am constructing a Sales Order Form and I keep getting an error message
that
I have too many arguments in the formula. The result that I am looking
for
is: In column E the user will enter a value; IF the value in column E is
<=
37, then multiply the value in column B by 14.3; IF the value in column E
is
37 and <= 43, then multiply the value in column B by 15.05; IF the value
in
column E is 43 and <=49, then mulitiply the value in column B by 15.8; IF
the value in column E is greater than 49, then return "Error - Check
O-T-O".
Any help would be appreciated.