Combining IF functions

Hi,

I have a similar problem. I am combining IF statements to give alternate answers, however my formula keeps returning the 1st answer no matter what figures I have in F3 and D3.

=IF((F3/D3)<=16.67,"A",IF(OR((F3/D3)>=16.68,(F3/D3)<=33.33),"B","C"))

Yappa

Still getting the same result. I have the value of 7 in D3 and the value of 2 in F3. With the current formula, this should give the result of 28.57 (2 divided by 7) and should be showing the result B.

Yappa

Hi, try
=IF(D3/F3>=33.33,"C",IF(and(D3/F3>16.67,D3/F3<33.33)"B","A"))
this works for me
Reagards Howard

Thanks EdMac and Gearcutter.
Just realised what i was doing wrong.

Yappa