Tax Number=Exemption
Posted by Wayne Corbeil on July 21, 2001 8:08 PM
Hello, I'm working on a price quote sheet, which allows entry of numerous items at various costs, which simply totals at the bottom of the page, including taxes. I wish to have a cell to designate a tax exemption number, (to use only in the case that the customer has an exemption number,) so that the cell that calculates tax would be nulified.
In other words, once I enter a number into a particular cell, what formula can I use to have it bring another cell (the one that calculates the tax) to 0?
Please e-mail your response.
Thank you in advance!
-Wayne
Posted by Aladin Akyurek on July 21, 2001 11:29 PM
Enter the following formula in the cell where you compute a total:
=IF(LEN(Exemption)>0,SUM(...),0)
This formula expects that the cell where you enter a tax exemption number is named Exemption via the Name Box and this cell is empty (contains no value although it may contain a formula that computes or retrieves a tax exemption number from a table in your workbook) if the customer is not subject to tax exemption.
Aladin
===============
