If statement to return blank if cell D1 is empty...

**bendixboogie** · 11-11-2008, 03:32 PM

Hello.

I have a problem with finding the right function. My goal is to have the following function...

The cell D1 has the following function: [=IF(B1<=C1;"YES";"NO")] But I would like to have the cell D1 to be left blank, if the cell A1 is blank.
How can I solve this Issue??

**modytrane** · 11-11-2008, 03:37 PM

Try this,

[=IF(A1="","",IF(B1<=C1;"YES";"NO"))]

Or

HTML Code:

**bendixboogie** · 11-11-2008, 03:56 PM

Originally Posted by modytrane

Try this,

[=IF(A1="","",IF(B1<=C1;"YES";"NO"))]

Or

HTML Code:

None of theese options are working...?

I'm using Excel 2007, if that makes any difference..

**arthurbr** · 11-11-2008, 03:59 PM

What does not work?
Do you get an eroor? Which one?

**arthurbr** · 11-11-2008, 04:02 PM

Replace commas (,) with semi coloms (; ) in the formula or the contrary depending on your regional settings

**bendixboogie** · 11-11-2008, 04:24 PM

Originally Posted by arthurbr

Replace commas (,) with semi coloms (; ) in the formula or the contrary depending on your regional settings

It still dosen't work...

It comes with an error saying 'error: invalid name'.

NOTE! I have a danish version of Excel, so I'm translating tekst to english.

**modytrane** · 11-11-2008, 04:48 PM

I didn't even notice the semicolons.
Try to use semicolons throughout.
I see that your original formula had ; in the IF statement.
In US we use , instead.
It should work if you use either all ; OR all ,
But you can't mix them.
modytrane.