Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror help
Hello,
I have the basic is error formula (=IF(ISERROR(AC21),"",AC21)) What I need help with is in cases where the formula is referencing a cell that has 0 or blank; how do I write the formula where it will return nothing if these two items appear? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror help
Try
=IF(ISERROR(AC21),"",IF(AC21=0,"",AC21)) "Jim" wrote: Hello, I have the basic is error formula (=IF(ISERROR(AC21),"",AC21)) What I need help with is in cases where the formula is referencing a cell that has 0 or blank; how do I write the formula where it will return nothing if these two items appear? Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror help
=IF(OR(AC21=0,ISERROR(AC21)),"",AC21))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jim" wrote: Hello, I have the basic is error formula (=IF(ISERROR(AC21),"",AC21)) What I need help with is in cases where the formula is referencing a cell that has 0 or blank; how do I write the formula where it will return nothing if these two items appear? Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Iserror help
IF(ISERROR(AC21),"",IF(OR(ISBLANK(AC21),A1=0),"",A C21))
-- Anne Murray "Jim" wrote: Hello, I have the basic is error formula (=IF(ISERROR(AC21),"",AC21)) What I need help with is in cases where the formula is referencing a cell that has 0 or blank; how do I write the formula where it will return nothing if these two items appear? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with ISERROR | Excel Worksheet Functions | |||
iserror help | Excel Worksheet Functions | |||
Iserror & VBA | Excel Discussion (Misc queries) | |||
ISERROR - #NAME? | Excel Worksheet Functions | |||
iserror | Excel Discussion (Misc queries) |