If statement

[sythong]

Hi to all Excel friends again

Am trying to accomplish the following:-

Cell F Cell H Cell I Cell J
Status Amt Taxable Exempt

Exempt 100 - 100
Taxable 50 50 -

I have managed to come up with
=IF(F28="Exempt",H28,""-"") for Cell J which works fine
but when copied to Cell I with modification of =IF(F24="Pay",H24,""-"")
it returns #VALUE when it should read 50

I am of the feeling that a nested if statement for Cell I and J would work if properly
syntax. Appreciate any suggestions as now manually keying in and prone to
error as sometime posted to wrong column.

 

[Robert Mika]

Hi sythong,

It should not read 50 as your value is "Taxable" when formula reads if F24="Pay" then return 50.

Chenge that to
=IF(F24="Pay",H24,"-")
instead
=IF(F24="Pay",H24,""-"")

that will read -.

 

[sythong]

Oops dopey me.

Robert Thanks very much for pointing out the error.

Cheers and happy weekend


Thong