IF Function

Question

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

sergeibaklan · Answer

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

sabrina lee · Answer

=IF(E1=D1,"YES","NO")E1 is =C1*5%&nbsp;&nbsp; (51.55*5% = 2.58)D1 = 2.58&nbsp;Coming up NO&nbsp;

sergeibaklan · Answer

Sabrina, 51.55*5% is 2.5775. &nbsp;It's not equal to 2.58, thus NO. You may use something like=IF(ROUND(E1,2)=D1,"YES","NO")&nbsp;

detlef_lewin · Answer

Sabrina,&nbsp;51.55 * 5% equal not 2.58 but 2.5775.&nbsp;

sabrina lee · Answer

&nbsp;Thank you!!!

Forum Discussion