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