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 :-)