Return Blank from If

[Jacob.Chandy]

I would like to return a blank value from an IF. i.e. let's say Cell B1 = 1 and Cell A1 contains IF(B1=1,B1,""). I want ISBLANK(A1) to return TRUE which it does not if this formula is used.

 

[VoG]

Perhaps look here http://www.mrexcel.com/forum/showthread.php?t=553333

 

[Jacob.Chandy]

Thanks...