IF or something else?

[513lette]

Hello! Im glad I found this forum, because Im pretty new to Excel, but I need to start learning it. Please let me know if I need to change how I attached a photo of the table.

I am trying to figure out how to take a column of numbers and multiply them by 2.75%, but I only need the formula to be applied to certain cells in that column. I tried the SUMIF formula a few times, but kept getting errors, so Im not sure if its me, or if its just not the right one to use.


Heres the table in question. I need to take the total column, and figure out how much in fees (2.75%) will come out of that, but only if the total is a result of a transaction that is listed under the card column, as fees aren't deducted from cash transactions. (its actually bigger than this, row wise, but I didn't want to talk up too much space)


[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]card[/TD]
[TD]cash[/TD]
[TD]Tax[/TD]
[TD]Tip[/TD]
[TD]total[/TD]
[TD]fee[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]100[/TD]
[TD]7.50[/TD]
[TD]10.00[/TD]
[TD]117.50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD]7.50[/TD]
[TD][/TD]
[TD]107.50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD]7.50[/TD]
[TD]6.50[/TD]
[TD]114.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD][/TD]
[TD]5.63[/TD]
[TD][/TD]
[TD]80.63[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, welcome to the forum!

Something like this maybe:

Excel 2013/2016
	A	B	C	D	E	F
1	card	cash	Tax	Tip	total	fee
2		100	7.5	10	117.5	0
3	100		7.5		107.5	2.95625
4	100		7.5	6.5	114	3.135
5	75		5.63		80.63	2.217325
Sheet1

Cell Formulas
Range	Formula
F2	=IF(A2>0,E2*2.75%,0)

 

[513lette]

Oh my, thats perfect, and so much easier than I was trying to make it. Thank you very much.

 

[RoryA]

Welcome to the forum.

For future reference, please read and follow the forum rules on cross-posting. Thanks.