IF function that recognizes "" in a cell.

[dcunningham]

Hi Everyone,

So I'm trying to create an IF function that will make a cell blank if another cell is blank. I've tried using =IF(ISBLANK(A1),"",A2), but even though A1 is 'blank' A2 is still returned. I believe this is because in A1 there's another IF function, =IF(A3>0,"",A4), which puts "" in A1 to make it blank. Is there a way to reference "" in an IF function? I tried something like =IF(A1="""","",A2) just to see, but that doesn't work either. I suppose an alternative would be to use something other than "", such as ERROR, and then use conditional formatting to make it blank, but I'd prefer to avoid doing that if possible.

Any guidance would be appreciated.

Regards,

Dan

 

[HolyExcel]

how about =if(CELL="",something,something else)

 

[RCBricker]

why not just =if(A1="","",A2)?

you are correct by the way A1 is not blank so isblank is return your else

rich

 

[dcunningham]

Well, now I feel silly. For some reason I had it in my head that the "" should be wrapped by " ". Brain fart I guess.

Thanks RCBricker and HolyExcel.

 

[RCBricker]

Well, now I feel silly. For some reason I had it in my head that the "" should be wrapped by " ". Brain fart I guess.

Thanks RCBricker and HolyExcel.

I spend more time looking crap up I already but cant think of than looking up new solutions.

rich