software

how can i remove the (#DIV/0!) when i have not data in the fields, but keep
the formulas in the particular field?You could use something like this:

=IF(ISERROR(formula),quot;quot;,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,
Elkarquot;sunderland27quot; wrote:

gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; the formulas in the particular field?
gt;

what is the 2nd formula listed below?

quot;Elkarquot; wrote:

gt; You could use something like this:
gt;
gt; =IF(ISERROR(formula),quot;quot;,formula)
gt;
gt; This will evaluate your formula, then, if an error is returned, it displays
gt; a blank, otherwise, the results of the formula are displayed.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; the formulas in the particular field?
gt; gt;

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),quot;quot;,A1 B1)

HTH,
Elkarquot;sunderland27quot; wrote:

gt; what is the 2nd formula listed below?
gt;
gt; quot;Elkarquot; wrote:
gt;
gt; gt; You could use something like this:
gt; gt;
gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt;
gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt;
gt; gt; HTH,
gt; gt; Elkar
gt; gt;
gt; gt;
gt; gt; quot;sunderland27quot; wrote:
gt; gt;
gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; the formulas in the particular field?
gt; gt; gt;

thank you

quot;Elkarquot; wrote:

gt; Its the same one.
gt;
gt; If [yourformula] is an error
gt; then display nothing
gt; else display [yourformula]
gt;
gt; For example, lets say your formula is A1 B1, then it would look like this:
gt;
gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; what is the 2nd formula listed below?
gt; gt;
gt; gt; quot;Elkarquot; wrote:
gt; gt;
gt; gt; gt; You could use something like this:
gt; gt; gt;
gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt;
gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt;
gt; gt; gt; HTH,
gt; gt; gt; Elkar
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt;

now that we have that. what can i do to leave fields blank if only one field
is populated

b1 = 2 c2 quot;blankquot; d1 = -.1 (what can i do to have d1 be blank until c2 is
populated with a number?)

quot;sunderland27quot; wrote:

gt; thank you
gt;
gt; quot;Elkarquot; wrote:
gt;
gt; gt; Its the same one.
gt; gt;
gt; gt; If [yourformula] is an error
gt; gt; then display nothing
gt; gt; else display [yourformula]
gt; gt;
gt; gt; For example, lets say your formula is A1 B1, then it would look like this:
gt; gt;
gt; gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt; gt;
gt; gt; HTH,
gt; gt; Elkar
gt; gt;
gt; gt;
gt; gt; quot;sunderland27quot; wrote:
gt; gt;
gt; gt; gt; what is the 2nd formula listed below?
gt; gt; gt;
gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You could use something like this:
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt; gt;
gt; gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt; gt;
gt; gt; gt; gt; HTH,
gt; gt; gt; gt; Elkar
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt; gt;

Try something like this:

=IF(OR(B1=quot;quot;,C2=quot;quot;),quot;quot;,yourformula)

Where yourformula is whatever you already have in D1.

HTH,
Elkarquot;sunderland27quot; wrote:

gt; now that we have that. what can i do to leave fields blank if only one field
gt; is populated
gt;
gt; b1 = 2 c2 quot;blankquot; d1 = -.1 (what can i do to have d1 be blank until c2 is
gt; populated with a number?)
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; thank you
gt; gt;
gt; gt; quot;Elkarquot; wrote:
gt; gt;
gt; gt; gt; Its the same one.
gt; gt; gt;
gt; gt; gt; If [yourformula] is an error
gt; gt; gt; then display nothing
gt; gt; gt; else display [yourformula]
gt; gt; gt;
gt; gt; gt; For example, lets say your formula is A1 B1, then it would look like this:
gt; gt; gt;
gt; gt; gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt; gt; gt;
gt; gt; gt; HTH,
gt; gt; gt; Elkar
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; what is the 2nd formula listed below?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; You could use something like this:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt; gt; gt;

How would i add this to my other formula =IF(ISERROR(A1 B1),quot;quot;,A1 B1)?quot;Elkarquot; wrote:

gt; Try something like this:
gt;
gt; =IF(OR(B1=quot;quot;,C2=quot;quot;),quot;quot;,yourformula)
gt;
gt; Where yourformula is whatever you already have in D1.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; now that we have that. what can i do to leave fields blank if only one field
gt; gt; is populated
gt; gt;
gt; gt; b1 = 2 c2 quot;blankquot; d1 = -.1 (what can i do to have d1 be blank until c2 is
gt; gt; populated with a number?)
gt; gt;
gt; gt; quot;sunderland27quot; wrote:
gt; gt;
gt; gt; gt; thank you
gt; gt; gt;
gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Its the same one.
gt; gt; gt; gt;
gt; gt; gt; gt; If [yourformula] is an error
gt; gt; gt; gt; then display nothing
gt; gt; gt; gt; else display [yourformula]
gt; gt; gt; gt;
gt; gt; gt; gt; For example, lets say your formula is A1 B1, then it would look like this:
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt; gt; gt; gt;
gt; gt; gt; gt; HTH,
gt; gt; gt; gt; Elkar
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; what is the 2nd formula listed below?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; You could use something like this:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt; gt; gt; gt;

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

=IF(OR(B1=quot;quot;,C2=quot;quot;,ISERROR(A1 B1)),quot;quot;,A1 B1)quot;sunderland27quot; wrote:

gt; How would i add this to my other formula =IF(ISERROR(A1 B1),quot;quot;,A1 B1)?
gt;
gt;
gt; quot;Elkarquot; wrote:
gt;
gt; gt; Try something like this:
gt; gt;
gt; gt; =IF(OR(B1=quot;quot;,C2=quot;quot;),quot;quot;,yourformula)
gt; gt;
gt; gt; Where yourformula is whatever you already have in D1.
gt; gt;
gt; gt; HTH,
gt; gt; Elkar
gt; gt;
gt; gt;
gt; gt; quot;sunderland27quot; wrote:
gt; gt;
gt; gt; gt; now that we have that. what can i do to leave fields blank if only one field
gt; gt; gt; is populated
gt; gt; gt;
gt; gt; gt; b1 = 2 c2 quot;blankquot; d1 = -.1 (what can i do to have d1 be blank until c2 is
gt; gt; gt; populated with a number?)
gt; gt; gt;
gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; thank you
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Its the same one.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If [yourformula] is an error
gt; gt; gt; gt; gt; then display nothing
gt; gt; gt; gt; gt; else display [yourformula]
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; For example, lets say your formula is A1 B1, then it would look like this:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; what is the 2nd formula listed below?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; You could use something like this:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; gt; gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt; gt; gt; gt; gt;

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=quot; quot;,G6=quot; quot;,ISERROR(F6/D6-1)),quot; quot;,F6/D6-1)

quot;Elkarquot; wrote:

gt; If you combine all of this into one formula, it would look like this:
gt;
gt; =IF(OR(B1=quot;quot;,C2=quot;quot;,ISERROR(A1 B1)),quot;quot;,A1 B1)
gt;
gt;
gt; quot;sunderland27quot; wrote:
gt;
gt; gt; How would i add this to my other formula =IF(ISERROR(A1 B1),quot;quot;,A1 B1)?
gt; gt;
gt; gt;
gt; gt; quot;Elkarquot; wrote:
gt; gt;
gt; gt; gt; Try something like this:
gt; gt; gt;
gt; gt; gt; =IF(OR(B1=quot;quot;,C2=quot;quot;),quot;quot;,yourformula)
gt; gt; gt;
gt; gt; gt; Where yourformula is whatever you already have in D1.
gt; gt; gt;
gt; gt; gt; HTH,
gt; gt; gt; Elkar
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; now that we have that. what can i do to leave fields blank if only one field
gt; gt; gt; gt; is populated
gt; gt; gt; gt;
gt; gt; gt; gt; b1 = 2 c2 quot;blankquot; d1 = -.1 (what can i do to have d1 be blank until c2 is
gt; gt; gt; gt; populated with a number?)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; thank you
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Its the same one.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; If [yourformula] is an error
gt; gt; gt; gt; gt; gt; then display nothing
gt; gt; gt; gt; gt; gt; else display [yourformula]
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; For example, lets say your formula is A1 B1, then it would look like this:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =IF(ISERROR(A1 B1),quot;quot;,A1 B1)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; what is the 2nd formula listed below?
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; quot;Elkarquot; wrote:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; You could use something like this:
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; =IF(ISERROR(formula),quot;quot;,formula)
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; This will evaluate your formula, then, if an error is returned, it displays
gt; gt; gt; gt; gt; gt; gt; gt; a blank, otherwise, the results of the formula are displayed.
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; HTH,
gt; gt; gt; gt; gt; gt; gt; gt; Elkar
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; quot;sunderland27quot; wrote:
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; gt; how can i remove the (#DIV/0!) when i have not data in the fields, but keep
gt; gt; gt; gt; gt; gt; gt; gt; gt; the formulas in the particular field?
gt; gt; gt; gt; gt; gt; gt; gt; gt;