Excel 2007 : IF(AND( conditional Formula Problem

[SIXFORTYSIX]

I'm trying to make a conditional statement that will Add its own text if the conditions are met. Can some one review it and tell me why they think its not working?

=IF(AND(ISBLANK($B9),(NOT($W9=0))),OFF,,)

[teylyn]

If you want to display text as the result of the IF, you need to wrap that text in quotes. There are only two words that can stand without quotes, i.e. the Boolean values True or False.

Also, your formula has too many commas.

Try

=IF(AND(ISBLANK($B9),(NOT($W9=0))),"OFF",FALSE)

[shg]

And more parens than it needs:

=IF(AND(ISBLANK($B9), $W9<>0), "OFF", "what it should say otherwise")

[SIXFORTYSIX]

Many thanks!

[SIXFORTYSIX]

=IF(AND(ISBLANK($B9),(NOT($W9=0))),"OFF",FALSE)

=IF(AND(ISBLANK($B9), $W9<>0), "OFF", "what it should say otherwise")

I've tried both above but it isn't displaying either of my text.

[daddylonglegs]

What's in B9, does it contain a formula?

[SIXFORTYSIX]

What's in B9, does it contain a formula?

B9 is a cell that is formatted for Time. By default it is blank.
It doesn't contain any formulas

[daddylonglegs]

So if you use this formula

=IF(AND(ISBLANK($B9), $W9<>0), "OFF", "what it should say otherwise")

....and B9 is blank and W9 is, say, 4 then you should get "OFF"? Is that what you expect. Does the formula work in that scenario?

[SIXFORTYSIX]

So if you use this formula

=IF(AND(ISBLANK($B9), $W9<>0), "OFF", "what it should say otherwise")

....and B9 is blank and W9 is, say, 4 then you should get "OFF"? Is that what you expect. Does the formula work in that scenario?

Yep thats what I'm looking for for the end result... but its not giving me any output.

[daddylonglegs]

Well, that formula can only give three possible results, OFF, what it should say otherwise or an error

Are you saying it returns nothing (a blank)?

Try checking the formatting of the cell with the formula and make sure it's set to general

[SIXFORTYSIX]

Are you saying it returns nothing (a blank)?

Nope not returning a blank, I'm not getting an error... It's just not working...

[teylyn]

What does it return, then? "Not working" is not good enough. What would you expect to be returned? Give concrete examples. Maybe it's time to post a workbook!!

[SIXFORTYSIX]

What does it return, then? "Not working" is not good enough. What would you expect to be returned? Give concrete examples. Maybe it's time to post a workbook!!

Well it doesn't return anything.... The cell just stays as is, blank.

[teylyn]

post a workbook.