Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
Hi,
A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
You need to use an if statement with it change A2 to your formula
=IF(ISERROR(A2),"",A2) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "NathanG" wrote: Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
=IF(ISERROR(A2),"",A2)
Iow, you do not need ISERROR on its own in A1 You could also say =IF(ISERROR(C1/D1),"",C1/D1) If say D1 equals 0 or "", then the cell containing the formula wil have "", else it will show the outcome, eg C1 = 10, D1 = 2, it will show 5 -- Hth Kassie Kasselman "NathanG" wrote: Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
Are you sure that masking errors is a good idea? Wouldn't it be wise to
check out why you get the #DIV/0? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
That helped but the #div/0! is still showing but the result of isr=error is.
I need both cells blank if a2 is #div/0! or if it isn't, the iserror result must be hidden but the value of A2 still show. Thanks "John Bundy" wrote: You need to use an if statement with it change A2 to your formula =IF(ISERROR(A2),"",A2) -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "NathanG" wrote: Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
If the source is legitimately 0, you could use a formula like
=IF(M1=0,"",N1/M1) which is far better than using ISERROR IMO. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob Phillips" wrote in message ... Are you sure that masking errors is a good idea? Wouldn't it be wise to check out why you get the #DIV/0? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
Close again but not quite. The cell with#div/0! is still showing.
Here are the values for the 2 cells concerned a1: =IF(ISERROR(A2),"","") a2: #div/0! As it stands cell a2 needs to be made blank and cell a1 remain blank. If a2 has a number in it i.e 17182 this must be shown but the a1 still be hidden. The customer is working on the logic for why #div occurs but we have been asked for it now to show on the sheet. Thanks "Bob Phillips" wrote: If the source is legitimately 0, you could use a formula like =IF(M1=0,"",N1/M1) which is far better than using ISERROR IMO. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob Phillips" wrote in message ... Are you sure that masking errors is a good idea? Wouldn't it be wise to check out why you get the #DIV/0? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
It is A2 that I am referring to, check that formula and adjust so that you
don't get #DIV/0 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Close again but not quite. The cell with#div/0! is still showing. Here are the values for the 2 cells concerned a1: =IF(ISERROR(A2),"","") a2: #div/0! As it stands cell a2 needs to be made blank and cell a1 remain blank. If a2 has a number in it i.e 17182 this must be shown but the a1 still be hidden. The customer is working on the logic for why #div occurs but we have been asked for it now to show on the sheet. Thanks "Bob Phillips" wrote: If the source is legitimately 0, you could use a formula like =IF(M1=0,"",N1/M1) which is far better than using ISERROR IMO. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob Phillips" wrote in message ... Are you sure that masking errors is a good idea? Wouldn't it be wise to check out why you get the #DIV/0? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use of ISERROR
Let me see if I understand what's going on here.
Your working information is all really in A2, but you want to hide any error displays in that cell, but for debugging/development purposes you want to see that error in A1? I'd something like this into the two cells: in A1: = If(IsError(N1/M1),N1/M1,"") while in A2 = If(IsError(N1/M1),"",N1/M1) substituting whatever the real formula used in A2 is right now for the N1/M1 statements in those formulas. "NathanG" wrote: Close again but not quite. The cell with#div/0! is still showing. Here are the values for the 2 cells concerned a1: =IF(ISERROR(A2),"","") a2: #div/0! As it stands cell a2 needs to be made blank and cell a1 remain blank. If a2 has a number in it i.e 17182 this must be shown but the a1 still be hidden. The customer is working on the logic for why #div occurs but we have been asked for it now to show on the sheet. Thanks "Bob Phillips" wrote: If the source is legitimately 0, you could use a formula like =IF(M1=0,"",N1/M1) which is far better than using ISERROR IMO. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Bob Phillips" wrote in message ... Are you sure that masking errors is a good idea? Wouldn't it be wise to check out why you get the #DIV/0? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NathanG" wrote in message ... Hi, A customer has asked me to supress any hashes. Typically the error is #div/0! I tried iserror(a2) and it came back true. If I change the value its false so that works. The thing is hiding the #div/0! and hiding the result of the iserror. So I need another formula with this logic if a2 is #div/0! then a2 = "" else if a2 = the value of A2 ( it can contain a number) and a1 (the result of Iserror) = "" (all the time no matter if is true or false) Thanks Nathan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with dividing and using ISERROR for Div/0! | Excel Worksheet Functions | |||
IF ISERROR | Excel Discussion (Misc queries) | |||
ISERROR | Excel Worksheet Functions | |||
ISERROR Conundrum | Excel Worksheet Functions | |||
ISERROR Functin to Much Work! | Excel Worksheet Functions |