Excel if formula help requesr

Closed
Manoj Dhulashia - 17 Mar 2010 à 12:35
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2010 à 16:33
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 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Mar 2010 à 16:33
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