View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eloughrey eloughrey is offline
external usenet poster
 
Posts: 1
Default 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.