I have a formula where it looks at the values in C11 and D11 and gives a result in E11.
If I enter cents in D11, I want Excel to round up to next whole dollar before subtracting from C11. How would I specify that? Here is my formula:
=CEILING(IF(D11<B11,A11,C11-D11),1)
If I enter cents in D11, I want Excel to round up to next whole dollar before subtracting from C11. How would I specify that? Here is my formula:
=CEILING(IF(D11<B11,A11,C11-D11),1)