View Single Post
  #1   Report Post  
Kel
 
Posts: n/a
Default 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 :-)