Home |
Search |
Today's Posts |
#1
|
|||
|
|||
iserror
Here is the formula that I am using:
=IF(ISBLANK(Q24),'SL&AH'!E24,'JL&AH'!E24). It works well once I input all of the numbers. However, before all the numbers are entered I get a DIV! error. How can I amend my formula to tell it to return a blank if I get this error? I fell certain I need to use the ISERROR function but I can't seem to get it to work. Any Ideas? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I throw in an ISERROR function on a complicated VVLOOKUP? | Excel Discussion (Misc queries) | |||
ISERROR VLOOKUP | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) | |||
Iserror and Vlookup | Excel Worksheet Functions | |||
ISERROR Functin to Much Work! | Excel Worksheet Functions |