#VALUE!
Is there a way to hide the "#value!" so it does not show in the cell?
|
#VALUE!
One way is to put a conditional format and look for
=ISERROR(A1) where A1 is the cell of interest. You can change the font to white. Alternatively, you could put =if(iserror(Your formula),"",Your formula) -- HTH, Barb Reinhardt "dwolf" wrote: Is there a way to hide the "#value!" so it does not show in the cell? |
#VALUE!
Hi
Try something like this: =If(IsError(yourFormula),"",yourFormula) Hopes this helps. .... Per On 11 Jan., 21:00, dwolf wrote: Is there a way to hide the "#value!" so it does not show in the cell? |
#VALUE!
As per the others. However, in some instances, you may be able to work
around the problem using inbuilt functions. Examples: Data A1 = 1 A2 = text A3 = 3 =A1+A2+A3 will return #value! whereas =Sum(A1:A3) will return 4. = A1*A2*A3 will return #value! whereas =Product (A1:A3) will return 3 -- Steve "dwolf" wrote in message ... Is there a way to hide the "#value!" so it does not show in the cell? |
#VALUE!
1) alter your formula
=IF(ISERROR(your_formula),"", your_formula) example IF(ISERROR(A1/B1),"",A1/B1) 2) use conditional formatting to hide #VALUE suppose the cell is B5; then use formula in conditional formatting =ISERROR(B5) and set the font color the same as the cell background thereby making it invisible (except when the cell is selected) . Method 1 is best if you are printing the worksheet best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "dwolf" wrote in message ... Is there a way to hide the "#value!" so it does not show in the cell? |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com