Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Any formulas to look up unsorted column ? | Excel Discussion (Misc queries) | |||
Excel 2002 - How to keep the formulas unchanged ? | Excel Discussion (Misc queries) | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Excel 2002 date formulas problem | Excel Worksheet Functions | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |