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)
<tbody>
</tbody>
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)
card | cash | Tax | Tip | total | fee |
100 | 7.50 | 10.00 | 117.50 | ||
100 | 7.50 | 107.50 | |||
100 | 7.50 | 6.50 | 114.00 | ||
75 | 5.63 | 80.63 |
<tbody>
</tbody>