Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by LLmca9 » Tue Sep 20, 2016 1:19 pm
I cannot figure out how to remove calculated sales tax in a column if that sale is exempt on a basic daily sales trx spreadsheet.
Column H is =F1*.0875 (F1 being the subtotal and .0875 is our sales tax rate). I have inserted column G before it where the sales clerks can enter a capital E if that customer is exempt. I want H to return the formula results if G is blank, or return 0.00 if G has the letter E in it.
Thank you!
-
LLmca9
- Rookie
-
- Posts: 2
- Joined: Sep 20, 2016
- Reputation: 0
- Excel Version: 2016
by ConneXionLost » Tue Sep 20, 2016 2:52 pm
In column H, replace your current formula with:
- Code: Select all
=IF(G1="E",0,F1)*0.0875
Cheers,
-
ConneXionLost
- Regular
-
- Posts: 68
- Joined: May 9, 2013
- Location: Canada
- Reputation: 19
- Excel Version: 2003, 2010
by LLmca9 » Wed Sep 21, 2016 10:46 am
Thank you!
-
LLmca9
- Rookie
-
- Posts: 2
- Joined: Sep 20, 2016
- Reputation: 0
- Excel Version: 2016
Return to General Excel Questions
Who is online
Users browsing this forum: Google [Bot], Google Adsense [Bot] and 54 guests