Forum Discussion
IF Function
Can I use IF function (yes/no) if one of the cells already has sum formula?
If your IF function will be in another cell - yes, why not
=IF(E1=D1,"YES","NO")
E1 is =C1*5% (51.55*5% = 2.58)
D1 = 2.58
Coming up NO
Sabrina,
51.55 * 5% equal not 2.58 but 2.5775.
Sabrina, 51.55*5% is 2.5775. It's not equal to 2.58, thus NO. You may use something like
=IF(ROUND(E1,2)=D1,"YES","NO")
Thank you!!!
