Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
Hi,
I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
Hello
Yes, for instance if you place such formula in say B1: =If(A1<"",A1/A2,"") It will remain empty("") if no value is found in A1. Else it will calculate division. HTH Cordially Pascal "Sasikiran" a écrit dans le message de news: ... Hi, I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
one way
=if(iserror(yourformula),"",yourformula) "Sasikiran" wrote: Hi, I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
HI Papou,
Can you please explain with this.. Im not getting A1 B1 C1 The formula in C1 is =(A1-B1)/A1 How do I change this? Thanks "papou" wrote: Hello Yes, for instance if you place such formula in say B1: =If(A1<"",A1/A2,"") It will remain empty("") if no value is found in A1. Else it will calculate division. HTH Cordially Pascal "Sasikiran" a écrit dans le message de news: ... Hi, I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
Thanks BJ... its working fine..
"bj" wrote: one way =if(iserror(yourformula),"",yourformula) "Sasikiran" wrote: Hi, I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
One way, slightly modified:
=IF(A1=0,"",(A1-B1)/A1)) or, equivalently: =IF(A1=0,"",1-B1/A1) In article , Sasikiran wrote: Can you please explain with this.. Im not getting A1 B1 C1 The formula in C1 is =(A1-B1)/A1 How do I change this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the error caused by the formula in a cell / column
I hope that you meant to test not A1 but A2, as that's where the divide
overflow comes from? -- David Biddulph "papou" wrote in message ... Hello Yes, for instance if you place such formula in say B1: =If(A1<"",A1/A2,"") It will remain empty("") if no value is found in A1. Else it will calculate division. HTH Cordially Pascal "Sasikiran" a écrit dans le message de news: ... Hi, I have a formula in a particular cell which calculates the quality % based on the numbers entered in another cells. I had included the formula in the required cell and it is appearing as "#DIV/0!" as error as I have not entered the data in the reference cells pertaining to the formula. Is there any way to hide the error symbol in that cell without deleting the formula? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When hiding column error messge"Can'nt shift object off sheet" | Excel Discussion (Misc queries) | |||
Error caused by *.xls file | Excel Discussion (Misc queries) | |||
Formula to sum every 4th cell returns #DIV/0! error in some column | Excel Worksheet Functions | |||
Excel Caused Error in VBE6.dll. Excel will Close | New Users to Excel | |||
Hiding a formula error | Excel Worksheet Functions |