Excel if formula help requesr

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i am entering my formula like " =IF(H5=AMC,"=M5*5%") " but i am gating error like #NAME, can any body help me to calculate 5% value of my M5 amount if H5 = amc.

thanks and regards

Manoj Dhulashia

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you should write formula like

=IF(H5="AMC"," M5*0.05, "")

"" means that if H5 is not AMC, then just put blank, Change if u have to