Forum Discussion
Sabrina Lee
Sep 20, 2017Copper Contributor
IF Function
Can I use IF function (yes/no) if one of the cells already has sum formula?
Sabrina Lee
Sep 20, 2017Copper Contributor
=IF(E1=D1,"YES","NO")
E1 is =C1*5% (51.55*5% = 2.58)
D1 = 2.58
Coming up NO
Detlef_Lewin
Sep 20, 2017Silver Contributor
Sabrina,
51.55 * 5% equal not 2.58 but 2.5775.