FALSE Statement

[Jay]

Hello,

I have a formula like this

K232=IF((J232="A"),-1*I232,IF((J232="B"),I232*F232,IF((J232="C"),0))

If there is nothing on J232 it displays FALSE , I would like to get rid
off this FALSE and cell should be blank, i tried IF(J232=""),"" but
again this arises another problem with other cell as this cell is
linked another worksheet which has formula to sum K9:K232

L6=SUMPRODUCT((MONTH('sheet2'!B5:B496)=1)*('sheet1'!K9:K500))

If i put IF(J232=""),"" its considering as a value not a empty cell ,

how do i rectify this

thank you in advance
regards
Jay

 

[Biff]

Hi!

A blank or empty cell will evaluate as month 1.

Just change this to test for numbers:

=SUMPRODUCT((MONTH('sheet2'!B5:B496)=1)*('sheet1'!K9:K500))

=SUMPRODUCT((ISNUMBER('sheet2'!B5:B496))*(MONTH('sheet2'!B5:B496)=1)*('sheet1'!K9:K500))

Biff

 

[Micah]

You probably got your answer already but the reason it's saying FALSE
is because you didn't specify what the result should be if J232 is
neither A, B nor C. It would look like this:

K232=IF((J232="A"),-1*I232,IF((J232="B"),I232*F232,IF((J232="C"),0),"Not
A, B or C")

Micah