Forum Discussion
Solved
Formula Help
Hello. I am a Novice Excel user. Here is my formula. I can get it to return a "2" but it always returns a "0" instead of a "1" =IF(OR(AND(C4>10,D4>8),C4<18,D4<16),1)*(IF(OR(C4>=18,D4>=16),2)) ...
- =MAX(ROUNDUP((C4-10)/8,0),ROUNDUP((D4-8)/8,0),0)
just added the ,0 at the end of the max list. that should work
mtarler THANKS!
This seems to do the trick. However, if I have blank columns/rows it seems to return a "-1". Any alteration to this you can think of? I have a formula at the bottom to calculate totals of each controller but with the negative values I am getting negative totals.
=MAX(ROUNDUP((C4-10)/8,0),ROUNDUP((D4-8)/8,0),0)
just added the ,0 at the end of the max list. that should work
just added the ,0 at the end of the max list. that should work