Forum Discussion
AndreiThornton
Feb 09, 2021Copper Contributor
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...
HansVogelaar
Feb 09, 2021MVP
- AndreiThorntonFeb 09, 2021Copper ContributorHi Hans,
I just adjusted to how you have written it and it works.
Thank you very much. - AndreiThorntonFeb 09, 2021Copper Contributor
Hi Hans,
I meant B.
B will be my independent variable.
This is what I have now.
=IF((P20>=M20),"9",ROUNDUP(P20))