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?

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?

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?

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?

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?

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?

Formula edit
 

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

If you combine all of this into one formula, it would look like this:

=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)


"sunderland27" wrote:

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

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" wrote:

If you combine all of this into one formula, it would look like this:

=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)


"sunderland27" wrote:

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

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" wrote:

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" wrote:

If you combine all of this into one formula, it would look like this:

=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)


"sunderland27" wrote:

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

F6 is blank D6=452

"Elkar" wrote:

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" wrote:

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" wrote:

If you combine all of this into one formula, it would look like this:

=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)


"sunderland27" wrote:

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?

Formula edit
 

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.


"sunderland27" wrote:

F6 is blank D6=452

"Elkar" wrote:

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" wrote:

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" wrote:

If you combine all of this into one formula, it would look like this:

=IF(OR(B1="",C2="",ISERROR(A1+B1)),"",A1+B1)


"sunderland27" wrote:

How would i add this to my other formula =IF(ISERROR(A1+B1),"",A1+B1)?


"Elkar" wrote:

Try something like this:

=IF(OR(B1="",C2=""),"",yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkar


"sunderland27" wrote:

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?