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
Thanks OliverScheurich
I did try this, and if the outputs match the inputs it works but like you said if they don't match I get no value.
That is why initially I was trying out a lot of IFs and ANDs and ORs as well as less than/greater than and equal to.
Ideally, I would like to be able to input any arbitrary input/output value and the formula would still input the controller count value.
Thank you for your response!
why can't you do something like:
=MAX(ROUNDUP((C4-10)/8,0),ROUNDUP((D4-8)/8,0))
=MAX(ROUNDUP((C4-10)/8,0),ROUNDUP((D4-8)/8,0))
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.