Quick IF statement required

[BMWE65]

Hi all,

Just need some quick help on creating an IF statement for my invoice.

I have a drop down box in cell J21, which lists Cash, Debit Card, Cheque and Credit Card.

If I select Credit Card from the drop down list, in cell E35 I want it to calculate 2.5% of the total invoice amount, (as there is a 2.5% fee associated with credit card purchases).

There are no fees for Cash, Debit Card or Cheque.

The total invoice amount is calculated by adding cells E32, E33 and E34.

Thanks very much

 

[VoG]

Try

=IF(J21="Credit Card",2.5%*SUM(E32:E34),0)

 

[Peter_SSs]

Edit: Oops, didn't see Vog's suggestion before posting.

Try this for E35

=SUM(E32:E34)*0.025*(J21="Credit Card")

 

[BMWE65]

Wow, thank you so much guys!!!
I have been trying myself all morning, and watching IF statement vids on youtube, and it just never worked out for me.

Thank you both! Worked a treat

 

[Peter_SSs]

Thank you both!

No, problem - and welcome to the MrExcel board!