IF Function

[Sabrina Lee]

Can I use IF function (yes/no)  if one of the cells already has sum formula?

[#2]

If your IF function will be in another cell - yes, why not

[#3]

=IF(E1=D1,"YES","NO")

E1 is =C1*5%   (51.55*5% = 2.58)

D1 = 2.58

Coming up NO

[#4]

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")

[#5]

Sabrina,

51.55 * 5% equal not 2.58 but 2.5775.

[#6]

 Thank you!!!