Excel 97 quote calculations

  • Thread starter Thread starter Satyajit Bhagwat
  • Start date Start date
S

Satyajit Bhagwat

Hi Jackie!

You could try extending the IF statement. I don't know whether it will work
in Excel 97 as I have only used Excel 2000, but here it is:

=IF(B4<40000,293.75,IF(B4<80000,323.13))

and so on.

Hope it works.

Satyajit
 
No basic worksheet functions have been added in recent versions, your
approach would work even in Excel 4 (and probably earlier). However,
you can have only 7 levels of nested functions in any version. A
VLOOKUP table would be much more flexible in terms of the number of
rates you could choose among.

Jerry
 
Back
Top