Forum Discussion
Excel IF formula with nested ROUNDUP function
Hello,
Any help on this matter would be greatly appreciated.
I am trying to make my if formula have to outcomes for its results and the test is if A is greater/equal to B.
If A is greater/equal than B I have the cell display a value of "9" if A is less than 8, I want it to display the rounded up number.
For example if A = 4.32 I want the cell to display 5.
The firsy part of the formula works fine, but I am not able to have it show the rounded up number if A is less than 9.
3 Replies
- Hi Hans,
I just adjusted to how you have written it and it works.
Thank you very much. Hi Hans,
I meant B.
B will be my independent variable.
This is what I have now.
=IF((P20>=M20),"9",ROUNDUP(P20))
