How do I right a formula for:
if column B (invoice number) equals "cash" then column H (HST @ 12% of B) equals 0
How do I right a formula for:
if column B (invoice number) equals "cash" then column H (HST @ 12% of B) equals 0
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
Audere est facere
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
OK, try this for H2
=IF(B2="Cash",0,E2*12%)
It worked! thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks