IF question references and empty cells

[NoobySE]

Hi, I try to create a function saying

in A6 the value of 'other sheet'! B2 should be shown; if 'other sheet'! B2 is empty, show 'other sheet'! A2 instead. but for some reason I don't get my head around that one last corner to get there any nudge is appreciated.

 

[NARAYANK991]

Hi NoobySE ,


Use the function ISBLANK to get what you want.


=IF(ISBLANK('other sheet'!B2),'other sheet'!A2,'other sheet'!B2) should do the job.


Narayan

 

[NoobySE]

Thank you so much Narayan, this did the trick. I was thinking around 2 corners too many

 

[NARAYANK991]

Hi ,


Thanks for the feedback. Keep visiting.


Narayan