Display a text but count as a num value?

  • Thread starter Thread starter Tim Gahnstroem
  • Start date Start date
T

Tim Gahnstroem

Hi

Is it possible to create a cell that displays a text but still have a
numeric value in formulas, much like the date-format.

I am looking for a function that takes itself as a parameter and based
on the value in the cell a string is shown to the user.

Or a function that takes two arguments :
Display(3,"this is three")

Or maybe a formatting thing.

What I really want is to be able to sometimes show a string saying
"you forgot this or that" and that cell should still count as 0 in all
other formulas. I don't want to change or formulas to look for the
textstring special case.

I have looked around google groups but not even found a similar
question, I hope that is because it is trivial and not because it is
obviously impossible. I cannot imagine I am the only one that wants
this feature.

Tim
 
this will sum h2:h5 ignoring h4 with dd & 33
=SUM(H2:H5)
this will include the 33 in h4
=SUM(H2:H5)+RIGHT(H4,2)
 
Use a Custom format in which you can specify conditions, like:

[=0]"You forgot something";0.00

or

[=3]"This is three";General
 
Back
Top