Useing "IF(ISERROR

[Bill R]

When a field is blank on sheets 'SL' or 'JL' I get a Div error. I want it to
just leave the field blank. The first formula shown below is correct but
returns the error. The 2nd formula does not work. What am I doing wrong?


=IF(ISBLANK(Q24),'SL&AH'!E24,'JL&AH'!E24)

=IF(ISERROR(IF(ISBLANK(AI24),SL!E24,JL!E24),"",IF(ISBLANK(AI24),SL!E24,JL!E24)))

 

[Kassie]

Hi Bill

In your first formula you refer to 'SL&AH'!E24 and to 'JL&AH'!E24. In the
second formula you refer to SL!E24 and JL!E24. Which do you want to refer to
here

 

[Bill R]

There were actually two different formulas for two different fields but they
both had the same problem. I was able to finally solve the problem myself.
Thank you anyway.
Here is my formula:
=IF(ISBLANK(BA6),"",IF(ISBLANK(Q24),'SL&AH'!E24,'JL&AH'!E24))