software

Hello,

I have in some cells some formulas that look for a value in other cells
and then do their calculations.
But when these cells, that are looked at, don't have a value in them
the other cells, waiting to calculate, end up with either a FALSE, ###,
or #VALUE! in the cell.

I would like to have these be blank when nothing is to be calculated.

Am I missing something in the formula to make these cells blank?

Thanks a lot,

Alan--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile: www.excelforum.com/member.php...oamp;userid=32944
View this thread: www.excelforum.com/showthread...hreadid=527813You could start by posting the formula(s)

=IF(looked_at_cell=quot;quot;,quot;quot;,your_formula)

would take care of empty cell

If you get false you have either an if function without anything in the (if
false do what)
or a condition like =A2gt;2--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;AnimatorElfquot; gt;
wrote in message
...
gt;
gt; Hello,
gt;
gt; I have in some cells some formulas that look for a value in other cells
gt; and then do their calculations.
gt; But when these cells, that are looked at, don't have a value in them
gt; the other cells, waiting to calculate, end up with either a FALSE, ###,
gt; or #VALUE! in the cell.
gt;
gt; I would like to have these be blank when nothing is to be calculated.
gt;
gt; Am I missing something in the formula to make these cells blank?
gt;
gt; Thanks a lot,
gt;
gt; Alan
gt;
gt;
gt; --
gt; AnimatorElf
gt; ------------------------------------------------------------------------
gt; AnimatorElf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32944
gt; View this thread: www.excelforum.com/showthread...hreadid=527813
gt;

Sorry, here they are.

=SUM(H15 J15) This one gives ###--gt; Cell H15 has =E9 in it.

=SUM(U8 X8 AA8 AD8 AG8) This one gives #VALUE!--gt; Cell X8 has =E10 in
it.

=IF(Z3=quot;Finequot;,quot;8quot;,IF(Z3=quot;Gargantuanquot;,quot;-4quot;,IF(Z3=quot;Hugequot;,quot;-2quot;,IF(Z3=quot;Largequot;,quot;-1quot;,IF(Z3=quot;Mediumquot;,quot;0quot;,IF(Z3=quot;Smallquot;,quot;1quot;,IF(Z3=quot;Tin yquot;,quot;2quot;,IF(Z3=quot;Diminutivequot;,quot;4quot;))))))))
This one gives FALSE--gt; Cell Z3 requires one of those 8 words to be
placed in it for this formula to quot;workquot;.

Almost all of my formulas require a number to be placed in Cells C8
thru C13. Once a number is placed in one of those cells, they all spit
out what I need, no errors.

Thanks again.
Alan--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile: www.excelforum.com/member.php...oamp;userid=32944
View this thread: www.excelforum.com/showthread...hreadid=5278131. If you have numbers in H15 and J15 this ##### means that you should widen
the column

also if you use SUM there is no need to use operators like

=SUM(H15,J15)

2. The values error is because there is a text value in one of the cells, if
you replace the signs with commas the text will be ignored which otoh
might not be what you want. Make sure all values are numbers3. You might want to remove the quotations around the numbers in your
formula quot;8quot; means that the result is text and will throw a value error, that
is not the reason you get false though. What do you want to happen if none
of the conditions are TRUE?

=IF(Z3=quot;Finequot;,8,IF(Z3=quot;Gargantuanquot;,-4,IF(Z3=quot;Hugequot;,-2,IF(Z3=quot;Largequot;,-1,IF(Z3=quot;Mediumquot;,0,IF(Z3=quot;Smallquot;,1,IF(Z3=quot;Tinyquot;,2, IF(Z3=quot;Diminutivequot;,4,quot;Something
elsequot;))))))))

will return quot;something elsequot;

=IF(Z3=quot;Finequot;,8,IF(Z3=quot;Gargantuanquot;,-4,IF(Z3=quot;Hugequot;,-2,IF(Z3=quot;Largequot;,-1,IF(Z3=quot;Mediumquot;,0,IF(Z3=quot;Smallquot;,1,IF(Z3=quot;Tinyquot;,2, IF(Z3=quot;Diminutivequot;,4,quot;quot;))))))))will return a blank, I would probably change the formula to

=IF(Z3=quot;quot;,quot;quot;,VLOOKUP(Z3,C714,2,0))

where C7quot;C14 would hold all possible words and D714 the numbers
(replace the range with a range that you want to use)

or hardcoded

=IF(Z3=quot;quot;,quot;quot;,VLOOKUP(Z3,{quot;Finequot;,8;quot;Gargantuanquot;,-4;quot;Hugequot;,-2;quot;Largequot;,-1;quot;Mediumquot;,0;quot;Smallquot;,1;quot;Tinyquot;,2;quot;Diminutivequot;,4},2, 0))
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;AnimatorElfquot; gt;
wrote in message
...
gt;
gt; Sorry, here they are.
gt;
gt; =SUM(H15 J15) This one gives ###--gt; Cell H15 has =E9 in it.
gt;
gt; =SUM(U8 X8 AA8 AD8 AG8) This one gives #VALUE!--gt; Cell X8 has =E10 in
gt; it.
gt;
gt; =IF(Z3=quot;Finequot;,quot;8quot;,IF(Z3=quot;Gargantuanquot;,quot;-4quot;,IF(Z3=quot;Hugequot;,quot;-2quot;,IF(Z3=quot;Largequot;,quot;-1quot;,IF(Z3=quot;Mediumquot;,quot;0quot;,IF(Z3=quot;Smallquot;,quot;1quot;,IF(Z3=quot;Tin yquot;,quot;2quot;,IF(Z3=quot;Diminutivequot;,quot;4quot;))))))))
gt; This one gives FALSE--gt; Cell Z3 requires one of those 8 words to be
gt; placed in it for this formula to quot;workquot;.
gt;
gt; Almost all of my formulas require a number to be placed in Cells C8
gt; thru C13. Once a number is placed in one of those cells, they all spit
gt; out what I need, no errors.
gt;
gt; Thanks again.
gt; Alan
gt;
gt;
gt; --
gt; AnimatorElf
gt; ------------------------------------------------------------------------
gt; AnimatorElf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32944
gt; View this thread: www.excelforum.com/showthread...hreadid=527813
gt;