Display a text but count as a num value?

[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

 

[Don Guillett]

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)

 

[Niek Otten]

Use a Custom format in which you can specify conditions, like:

[=0]"You forgot something";0.00

or

[=3]"This is three";General

 

[Tim Gahnstroem]

"Niek Otten" replied

Use a Custom format in which you can specify conditions, like:

[=0]"You forgot something";0.00
[=3]"This is three";General

Thanks, that wasexactly what I was looking for.

Tim