Sep 20 2017
01:03 PM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
Sep 20 2017
01:03 PM
- last edited on
Jul 25 2018
10:05 AM
by
TechCommunityAP
Can I use IF function (yes/no) if one of the cells already has sum formula?
Sep 20 2017 01:18 PM
=IF(E1=D1,"YES","NO")
E1 is =C1*5% (51.55*5% = 2.58)
D1 = 2.58
Coming up NO
Sep 20 2017 01:24 PM
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")