FALSE Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 26 Sep 2006 22:42 GMT

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

Reply to this Message

Biff - 26 Sep 2006 23:03 GMT

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

> Hello,
>
[quoted text clipped - 16 lines]
> regards
> Jay

Reply to this Message

Micah - 27 Sep 2006 08:33 GMT

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

> Hello,
>
[quoted text clipped - 16 lines]
> regards
> Jay

Reply to this Message

Rate this thread: