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?

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

worksheet attached

Attached Files

testing.xlsx (9.0 KB, 14 views)

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you

Most welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post