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
An alternative is to use INDEX and MATCH with a table such as the attached. This table could easily be extended; I only took it this far to illustrate the concept.
As is always the case (as your now two replies illustrate) there are always multiple ways in Excel to get from point A to point B.