Forum Discussion

oregonsue's avatar
oregonsue
Copper Contributor
Apr 16, 2021

Using IF function

Mac OS Big Sur 11.2.3. Excel version 16.48   Sounds simple really, but cannot get correct answer. One of the cells in the IF function contains a formula. How can you indicate to use the Value of th...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 16, 2021

oregonsue That formula should work just fine, as Excel compares the result of the formula to the value in the other cell. Could it be that the formula in O2 results in a number that has more or different decimals that the amount in R2, and that both numbers are just formatted to display, for instance 2 decimals? Try entering in an empty cell =O2=R2 . What do you get? In case it is FALSE, then the two numbers are not exactly the same and your formula will return "PmtOwed". Is that what's happening?

If so, you perhaps need add ROUND to the sum formula. But without seeing it and the exact (unrounded) result and the exact amount in R2, it's difficult to give you the correct solution. 

Change the SUM formula to something like this:

=ROUND(SUM(<range>),2)

 or change the IF formula to:

=IF(ROUND(O2,2)=R2,"PdFull","PymtOwed")

 Both assume you want 2 decimals.

Resources