text in formula

[maureen]

Help!!!
Is there a way to have a formula where a cell with text is
in it, but it is not included in the formula. Like I have
a random cell that appears sometimes within the range but
because it is text and I do not want to include it in the
formula. Is there a certain "symbol" that could be used?
HELP!!

 

[Guest]

Hi maureen,

It depends on what the actual formula is, but *some*
functions ignore text entries. You could use the ISNUMBER
function to include only those entries that are numbers.
Post your formula for a more detailed reply.

Biff

 

[Maureen]

Ok, say the original formula was =sum(B24:B32) but then
someone uses cell B28 for text, like "missing" for
example. It is a fairly large spreadsheet, so I wouldn't
want to re-invent the wheel, so how could I set it up to
ignore text if it is entered? Thanks for your help, and
can you show me the formula. I am VERY NEW IN EXCEL.

 

[RagDyer]

Sum ignores text entries within it's range.

=SUM(B24:B32) will still return a valid total with "missing" being entered
in B28.

Have you tried it ?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Ok, say the original formula was =sum(B24:B32) but then
someone uses cell B28 for text, like "missing" for
example. It is a fairly large spreadsheet, so I wouldn't
want to re-invent the wheel, so how could I set it up to
ignore text if it is entered? Thanks for your help, and
can you show me the formula. I am VERY NEW IN EXCEL.

 

[maureen]

Ok, it must have been a more involved formula. Please, is
there a way to isolate a cell from a formula if it has
text rather than a number value?

 

[RagDyer]

There are different procedures for different types of functions.

Post back with a specific formula.
--


Regards,

RD