Forum Discussion
Solved
Assistance with nested IF
Good Evening I need some assistance. I have a column with numbers and need to do the following calculation: IF b1 > 100 allocate 3 and for every additional 150 beds i must add 1 to the 3. If ...
Hello Naaz2006
Maybe like this;
If less than 100, use zero. Otherwise, 3 plus one for each the number above 100 that is fully 150.
=IF(B2:B11<100;0;3+INT((B2:B11-100)/150))
Hello Naaz2006
Maybe like this;
If less than 100, use zero. Otherwise, 3 plus one for each the number above 100 that is fully 150.
=IF(B2:B11<100;0;3+INT((B2:B11-100)/150))
bosinander , Thank you. It is working . Your assistance is highly appreciated
You're welcome 🙂 And, as you can see, Riny_van_Eekelen shows another way to solve it. Understanding different approaches enables more possibilities to solve future needs.
