What's wrong in this formula????

[Ekser]

Hm....

Using this formula:
=IF(J3>2,G3*(J3*25),IF(J3>3,G3*(J3*50),IF(J3>4,G3*(J3*75),IF(J3>5,G3*(J19*100)))))

I get this:

G3 = 3
J3 returns result of 4
So I should get (3*150) = 450....but I get 600.00

Same J3, and G3 = 2.
I should have (2*150) = 300 ... but I get 400

G3=3
J3 returns 3
I should get (3*125) = 375... but I get 450



Any idea

 

[Guest]

hi,
I see 2 things
1. all the numbers are greater than 2 so it is hitting the
first condition every time.
in this situation i would try if(J3 = 2,......
2. you don't have a 2nd contitions in your last if.
try......If(J2 >5,G3*(J19*100),0)
regards

 

[Don Guillett]

When doing this I always start with the largest number and work my way down.

5 >4 >3

but why don't you just try what I offered before?
=G19*MIN(200,50+25*J19)