| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula edit
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula edit
You could use something like this:
=IF(ISERROR(formula),"",formula) This will evaluate your formula, then, if an error is returned, it displays a blank, otherwise, the results of the formula are displayed. HTH, Elkar "sunderland27" wrote: how can i remove the (#DIV/0!) when i have not data in the fields, but keep the formulas in the particular field? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula edit
what is the 2nd formula listed below?
"Elkar" wrote: You could use something like this: =IF(ISERROR(formula),"",formula) This will evaluate your formula, then, if an error is returned, it displays a blank, otherwise, the results of the formula are displayed. HTH, Elkar "sunderland27" wrote: how can i remove the (#DIV/0!) when i have not data in the fields, but keep the formulas in the particular field? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula edit
Its the same one.
If [yourformula] is an error then display nothing else display [yourformula] For example, lets say your formula is A1+B1, then it would look like this: =IF(ISERROR(A1+B1),"",A1+B1) HTH, Elkar "sunderland27" wrote: what is the 2nd formula listed below? "Elkar" wrote: You could use something like this: =IF(ISERROR(formula),"",formula) This will evaluate your formula, then, if an error is returned, it displays a blank, otherwise, the results of the formula are displayed. HTH, Elkar "sunderland27" wrote: how can i remove the (#DIV/0!) when i have not data in the fields, but keep the formulas in the particular field? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula edit
thank you
"Elkar" wrote: Its the same one. If [yourformula] is an error then display nothing else display [yourformula] For example, lets say your formula is A1+B1, then it would look like this: =IF(ISERROR(A1+B1),"",A1+B1) HTH, Elkar "sunderland27" wrote: what is the 2nd formula listed below? "Elkar" wrote: You could use something like this: =IF(ISERROR(formula),"",formula) This will evaluate your formula, then, if an error is returned, it displays a blank, otherwise, the results of the formula are displayed. HTH, Elkar "sunderland27" wrote: how can i remove the (#DIV/0!) when i have not data in the fields, but keep the formulas in the particular field? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula edit
now that we have that. what can i do to leave fields blank if only one field
is populated b1 = 2 c2 "blank" d1 = -.1 (what can i do to have d1 be blank until c2 is populated with a number?) "sunderland27" wrote: thank you "Elkar" wrote: Its the same one. If [yourformula] is an error then display nothing else display [yourformula] For example, lets say your formula is A1+B1, then it would look like this: =IF(ISERROR(A1+B1),"",A1+B1) HTH, Elkar "sunderland27" wrote: what is the 2nd formula listed below? "Elkar" wrote: You could use something like this: =IF(ISERROR(formula),"",formula) This will evaluate your formula, then, if an error is returned, it displays a blank, otherwise, the results of the formula are displayed. HTH, Elkar "sunderland27" wrote: how can i remove the (#DIV/0!) when i have not data in the fields, but keep the formulas in the particular field? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to edit formula | Excel Worksheet Functions | |||
| cursor locked, won't allow move, repeat or formula edit | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| how do I get the edit button back on the formula bar? | Excel Discussion (Misc queries) | |||
| How do I edit a formula as part of a macro? | Excel Discussion (Misc queries) | |||
Hybrid Mode
