IF or something else?

513lette

New Member
Joined
Jun 4, 2019
Messages
2
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)


cardcashTaxTiptotalfee
1007.5010.00117.50
1007.50107.50
1007.506.50114.00
755.6380.63

<tbody>
</tbody>


 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi, welcome to the forum!

Something like this maybe:


Excel 2013/2016
ABCDEF
1cardcashTaxTiptotalfee
21007.510117.50
31007.5107.52.95625
41007.56.51143.135
5755.6380.632.217325
Sheet1
Cell Formulas
RangeFormula
F2=IF(A2>0,E2*2.75%,0)
 
Upvote 0
Welcome to the forum. :)

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

Forum statistics

Threads
1,213,543
Messages
6,114,245
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top