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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,535
Office Version
  1. 365
Platform
  1. Windows
Hi, welcome to the forum!

Something like this maybe:

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">card</td><td style=";">cash</td><td style=";">Tax</td><td style=";">Tip</td><td style=";">total</td><td style=";">fee</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;">100</td><td style="text-align: right;;">7.5</td><td style="text-align: right;;">10</td><td style="text-align: right;;">117.5</td><td style="text-align: right;background-color: #FFFF00;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">100</td><td style="text-align: right;;"></td><td style="text-align: right;;">7.5</td><td style="text-align: right;;"></td><td style="text-align: right;;">107.5</td><td style="text-align: right;;">2.95625</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">100</td><td style="text-align: right;;"></td><td style="text-align: right;;">7.5</td><td style="text-align: right;;">6.5</td><td style="text-align: right;;">114</td><td style="text-align: right;;">3.135</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">75</td><td style="text-align: right;;"></td><td style="text-align: right;;">5.63</td><td style="text-align: right;;"></td><td style="text-align: right;;">80.63</td><td style="text-align: right;;">2.217325</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=IF(<font color="Blue">A2>0,E2*2.75%,0</font>)</td></tr></tbody></table></td></tr></table><br />
 

513lette

New Member
Joined
Jun 4, 2019
Messages
2
Oh my, thats perfect, and so much easier than I was trying to make it. Thank you very much.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,103
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Welcome to the forum. :)

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

Forum statistics

Threads
1,136,283
Messages
5,674,831
Members
419,529
Latest member
TommasoP11

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
Top