nested IF formula question
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?
Last edited by H28Sailor; 05-12-2017 at 12:38 AM.
Reason: correction
|