What's wrong in this formula????

[Ekser]

=IF(J19=2,G19*100,IF(J19=3,G19*125,IF(J19=4,G19*150,IF(J19=5,G19*175,IF(J19>5,G19*200)))))


I get a return 'FALSE'?!

In this case, J19 = 3.00 (number, two decimals as result of anothe
formula)and G19 = 2, so it should return 2.00


:cool

 

[Don Guillett]

one way if the max is 200
=G19*MIN(200,75+25*J19)

 

[Don Guillett]

should be 50
=G19*MIN(200,50+25*J19)

=G19*MIN(200,75+25*J19)

--
Don Guillett
SalesAid Software
(e-mail address removed)

one way if the max is 200
=G19*MIN(200,75+25*J19)

 

[Jerry W. Lewis]

In an empty cell enter the formula
=(J19-3)
You will find that the value in J19 is not exactly 3. Your formula only
defines an output if J19 is exactly 2,3,4 or 5, or if J19>5 (which also
includes most text values); any other value and it will return FALSE.

You can set up inequality conditions, condition on ROUND(J19,2), or at
the menu item Tools|Options|Calculation and check "Precision as
displayed" (which will impact all calculations, not just this one).

Jerry