if column B equals "cash" then column H equals 0

[im3d]

How do I right a formula for:

if column B (invoice number) equals "cash" then column H (HST @ 12% of B) equals 0

[daddylonglegs]

Perhaps try this in H2

=N(B2)*12%

That will give 12% of B2 but if B2 is not a number (e.g. text like "cash") the formula will return 0

[im3d]

Perhaps try this in H2

=N(B2)*12%

That will give 12% of B2 but if B2 is not a number (e.g. text like "cash") the formula will return 0

Thanks, I tried it,then realized I omitted that the 12% was derived from column "E"

so column B is either an invoice number (ie "23456" or "cash")
.... column E is the amount charged (ie $100)
and column H is 12% of column E (ie $12 or hopefully $0 if I can get the formula to read the column B entry of "cash" as not a number)

Clear as mud I'm sure, any help is appriciated

[daddylonglegs]

OK, try this for H2

=IF(B2="Cash",0,E2*12%)

[im3d]

It worked! thanks a bunch!