=IF(ISBLANK help

[tidnab312]

Somewhere my syntax is wrong
This cell value =INDIRECT("'"&F24 &"'!G25") works fine but if the value is blank it returns a 0

so I tried this
=IF(ISBLANK(INDIRECT("'"&F24 &"'!G25"),"",INDIRECT("'"&F24 &"'!G25")

I have a feeling I'm missing a ' or an ) somewhere but I can't figure it out

 

[repairman615]

Hello,

Maybe:

=IF(ISBLANK(INDIRECT("'"&F24&"'!G25")),"",INDIRECT("'"&F24&"'!G25"))

 

[jeffreybrown]

Are you talking about G25 is blank?

=IF(G25="","",INDIRECT("'"&F24&"'!G25"))

 

[tidnab312]

I tried that syntax and it keeps giving an error and pointing to the ,"", section.

secondly,

It's not just !G25 it's the entire value of INDIRECT("'"&F24&"'!G25") that will be blank

=IF(ISBLANK(INDIRECT("'"&F24&"'!G25"),"",INDIRECT("'"&F24&"'!G25"))

the =INDIRECT("'"&F24 &"'!"&G25) works fine I just want it to return "" if it's blank and returnthe value =INDIRECT("'"&F24 &"'!"&G27) if it's not blank

 

[repairman615]

Did you try the formula I posted?

 

[jeffreybrown]

What version of Excel do you have?

Maybe...

2007+
=IFERROR(INDIRECT("'"&F24&"'!G25"),"")

2003
=IF(ISERROR(INDIRECT("'"&F24&"'!G25")),"",INDIRECT("'"&F24&"'!G25"))

 

[T. Valko]

Somewhere my syntax is wrong
This cell value =INDIRECT("'"&F24 &"'!G25") works fine but if the value is blank it returns a 0

so I tried this
=IF(ISBLANK(INDIRECT("'"&F24 &"'!G25"),"",INDIRECT("'"&F24 &"'!G25")

I have a feeling I'm missing a ' or an ) somewhere but I can't figure it out

Try it like this:

=IF(INDIRECT("'"&F24 &"'!G25")="","",INDIRECT("'"&F24 &"'!G25"))

 

[tidnab312]

sweet 2 solutions both jeffrey and T Valco's solutions worked
gotta add this to my stash of knowledge
THANKS!!

repairman... I'm using 2007 and didn't have any luck with that string working :S now I just gotta figure out the other solutions worked


Thanks Again!!!

 

[jeffreybrown]

Glad you found something to work with

 

[T. Valko]

sweet 2 solutions both jeffrey and T Valco's solutions worked
gotta add this to my stash of knowledge
THANKS!!

repairman... I'm using 2007 and didn't have any luck with that string working :S now I just gotta figure out the other solutions worked


Thanks Again!!!

You're welcome. Thanks for the feedback!