Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I create a formula to calculate sales tax using Yes & No
I have a spreadsheet set up and two of the columns will have yes or no in them, I want to calculate the sales tax that was included in the po......see below...... PO Amt. Taxable material Taxes Included in PO Sales Tax Due $900.94 Yes Yes $68.64 (how do I get this # with a formula) thanks for your help!!! Kel :-) |
#2
|
|||
|
|||
In your Sales Tax Due cell, I assume it's D2, put this formula..........copy
down if desired....... =IF(C2="YES",A2*.076187 Or, you can put the Sales Tax Percentage in a cell like E2, and use this..... =IF(C2="YES",A2*E2 Vaya con Dios, Chuck, CABGx3 "Kel" wrote in message ... I have a spreadsheet set up and two of the columns will have yes or no in them, I want to calculate the sales tax that was included in the po......see below...... PO Amt. Taxable material Taxes Included in PO Sales Tax Due $900.94 Yes Yes $68.64 (how do I get this # with a formula) thanks for your help!!! Kel :-) |
#3
|
|||
|
|||
Kel
Not sure what you need here. Do you want to compute the Tax Due if Taxes Included in PO is yes and nothing if no? Assuming Tax Due is column D In D2 enter =IF(C2="yes",A2*taxrate,"") If I have missed the mark, post back or wait for other interpretations. Gord Dibben Excel MVP On Wed, 13 Apr 2005 14:54:02 -0700, Kel wrote: I have a spreadsheet set up and two of the columns will have yes or no in them, I want to calculate the sales tax that was included in the po......see below...... PO Amt. Taxable material Taxes Included in PO Sales Tax Due $900.94 Yes Yes $68.64 (how do I get this # with a formula) thanks for your help!!! Kel :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create an excel formula with contitions | Excel Worksheet Functions | |||
How to create a formula for this function. | Excel Worksheet Functions | |||
How do I create a formula that will calculate monthly changes fro. | Excel Worksheet Functions | |||
create a chart with a formula | Charts and Charting in Excel | |||
What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions |