Problems with IF statement

  • Thread starter Thread starter terry_d
  • Start date Start date
T

terry_d

=IF(F35=0,0,IF(F35<=50,20,MAX(30,F35*0.15)))

This is the function I'm using to figure car mileage pay.

Trying to figure out how to get: If the driver drives 1 to 50 miles,
they receive $20.00, 50 miles to 200, they receive $30.00, 200 or more
miles, they are paid $0.15 per mile...

The function above works very well, but I'm receiving errors.
Formatting errors. The cells containing the function are formatted to
numbers, with 2 decimals. This is a worksheet full of formualas &
functions, I have not received any such errors prior to inserting this
statement.

Thanks,

Terry
 
I receive the error when I do a save. It tells me "A formula in a ce
could not be converted because it contains a function that is no
available in the file format to which you are saving..
 
Back
Top