nested IF formula question

[H28Sailor]

Hi

C2, D2.....L2 hold prices
N2 holds max of C2:L2
O2 holds min of C2:L2
P2 holds (N2-O2)/8



My formula in R2:-

=IF(C2=O2,0,IF(C2=N2,9,INT((C2-O2)*P2)))

but I get a zero when C2 does not equal either N2 or O2?

What am I doing wrong?

[xor]

Cannot replicate that problem.
For me your formula works just fine.

[H28Sailor]

worksheet attached

[Pecoflyer]

Just remove the INT function =IF(C2=$O2,0,IF(C2=$N2,9,((C2-$O2)*$P2)))

It returns the integer part and as all your differences are lower than 1 you always get 0 which is the integer part of any number between 1 and 0

[H28Sailor]

Thank you

[Pecoflyer]

Most welcome