S
sunderland27
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
the formulas in the particular field?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
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
=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
S
sunderland27
what is the 2nd formula listed below?
Elkar said: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
E
Elkar
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
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
S
sunderland27
thank you
Elkar said: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 said:what is the 2nd formula listed below?
S
sunderland27
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?)
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 said:thank you
Elkar said: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 said:what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
E
Elkar
Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
sunderland27 said: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 said:thank you
Elkar said: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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
S
sunderland27
How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
Elkar said:Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
sunderland27 said: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 said:thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
E
Elkar
If you combine all of this into one formula, it would look like this:
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
sunderland27 said:How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
Elkar said:Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
sunderland27 said: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?)
:
thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
S
sunderland27
below is my formula. the only thing that populates my desired field is a 0
and that is the only thing that will populate.
=IF(OR(F6=" ",G6=" ",ISERROR(F6/D6-1))," ",F6/D6-1)
and that is the only thing that will populate.
=IF(OR(F6=" ",G6=" ",ISERROR(F6/D6-1))," ",F6/D6-1)
Elkar said:If you combine all of this into one formula, it would look like this:
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
sunderland27 said:How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
Elkar said:Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
:
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?)
:
thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
E
Elkar
Maybe try taking out the spaces in your quotes? A space " " and a blank ""
are two different things.
If that doesn't work, then what values are in F6 and D6?
are two different things.
If that doesn't work, then what values are in F6 and D6?
sunderland27 said:below is my formula. the only thing that populates my desired field is a 0
and that is the only thing that will populate.
=IF(OR(F6=" ",G6=" ",ISERROR(F6/D6-1))," ",F6/D6-1)
Elkar said:If you combine all of this into one formula, it would look like this:
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
sunderland27 said:How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
:
Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
:
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?)
:
thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
S
sunderland27
F6 is blank D6=452
Elkar said:Maybe try taking out the spaces in your quotes? A space " " and a blank ""
are two different things.
If that doesn't work, then what values are in F6 and D6?
sunderland27 said:below is my formula. the only thing that populates my desired field is a 0
and that is the only thing that will populate.
=IF(OR(F6=" ",G6=" ",ISERROR(F6/D6-1))," ",F6/D6-1)
Elkar said:If you combine all of this into one formula, it would look like this:
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
:
How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
:
Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
:
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?)
:
thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?
E
Elkar
The formula should result in a blank, not 0. Do you have custom formatting
applied to the cell? Try changing the cell format to General.
applied to the cell? Try changing the cell format to General.
sunderland27 said:F6 is blank D6=452
Elkar said:Maybe try taking out the spaces in your quotes? A space " " and a blank ""
are two different things.
If that doesn't work, then what values are in F6 and D6?
sunderland27 said:below is my formula. the only thing that populates my desired field is a 0
and that is the only thing that will populate.
=IF(OR(F6=" ",G6=" ",ISERROR(F6/D6-1))," ",F6/D6-1)
:
If you combine all of this into one formula, it would look like this:
=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)
:
How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?
:
Try something like this:
=IF(OR(B1="",C2=""),"",yourformula)
Where yourformula is whatever you already have in D1.
HTH,
Elkar
:
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?)
:
thank you
:
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
:
what is the 2nd formula listed below?
:
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
:
how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?