Useing "IF(ISERROR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)))
 
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
 
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))
 
Back
Top