Calculating Card Surcharge, only when paying by card

Hi,

Im trying to calculate a sum (which i can do), however im stuggling with the code to make that cell also calculate a card surcharge. So for example, on an invoice- a customer is paying by card which will be indicated by "Y" for yes and "N" for no. Obvioulsy if it is yes I need a 2% charge added to the sum and if No, then just the sum with no 2% charge. This needs to be all within the same cell. The Card Surcharge where I will type "Y" or "N" will be the cell above.

Any help with what code I should be writing would be a great help. I have a feeling it would be sort sort of SUMIF code?

Many thanks

Hi OneScotty2Hotty,

A regular IF formula should be all you need.

=IF(Ref of Y/N cell = "Y",ref of cell containing the sum * 1.02, ref of cell containing the sum)

I hope this makes sense? If not give me a shout.

Regards,

Snook

Hi The_Snook,

thank you very much for your help. However im still having problems?Screenshot (3).png

So my sum formula is in the subtotal box. I still want this to calculate cells H22:H39 but also * by 1.02 if cell H45 (card surcharge cell) contains "Y". Is the formula still the correct one as I kept getting an error message?

Many thanks

Try in cell H46:

=IF(H45="Y",SUM(H22:H39)*1.02,SUM(H22:H39))

Regards,

Snook

You sir are an absolute Hero! You wouldn't believe the amount of time ive spent searching google, trying to figure that out. All of my excel knowledge has long been forgotton!

Many thanks!

You're welcome mate, happy to help.