New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need help returning a Formula or zero

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Need help returning a Formula or zero

Postby 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!
  • 0

LLmca9
Rookie
 
Posts: 2
Joined: Sep 20, 2016
Reputation: 0
Excel Version: 2016

Re: Need help returning a Formula or zero

Postby 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,
  • 0

ConneXionLost
Regular
 
Posts: 68
Joined: May 9, 2013
Location: Canada
Reputation: 19
Excel Version: 2003, 2010

Re: Need help returning a Formula or zero

Postby LLmca9 » Wed Sep 21, 2016 10:46 am

Thank you!
  • 0

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] and 61 guests

cron