[peabody]

Is it possible to have the program do nothing if the condition is false?
If H20,"cancelled",do nothing - no change to the current content of the cell.

[David Biddulph[_2_]]

The current content of the cell is the formula you've just typed into it.
--
David Biddulph

"peabody" wrote in message
...
Is it possible to have the program do nothing if the condition is false?
If H20,"cancelled",do nothing - no change to the current content of the
cell.

[shb]

Just type

=if(H20,"cancelled","")

The double quotes will return nothing for you.

"peabody" wrote:

Is it possible to have the program do nothing if the condition is false?
If H20,"cancelled",do nothing - no change to the current content of the cell.

[Bob Phillips]

No, because as soon as you put a formula in there, the existing value is
over-written.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"peabody" wrote in message
...
Is it possible to have the program do nothing if the condition is false?
If H20,"cancelled",do nothing - no change to the current content of the
cell.

[Niek Otten]

Hi David,

That's a real nice, easy to understand explanation, thanks!
I'll keep it in my list for future use (of course I'll quote you)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
| The current content of the cell is the formula you've just typed into it.
| --
| David Biddulph
|
| "peabody" wrote in message
| ...
| Is it possible to have the program do nothing if the condition is false?
| If H20,"cancelled",do nothing - no change to the current content of the
| cell.
|
|

[David Biddulph[_2_]]

Thank you, Niek
I try to keep my explanations sufficiently simple that even I can understand
them. :-)
--
David Biddulph

"Niek Otten" wrote in message
...
Hi David,

That's a real nice, easy to understand explanation, thanks!
I'll keep it in my list for future use (of course I'll quote you)

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
| The current content of the cell is the formula you've just typed into
it.

| "peabody" wrote in message
| ...
| Is it possible to have the program do nothing if the condition is
false?
| If H20,"cancelled",do nothing - no change to the current content of
the
| cell.

[Bernard Liengme]

I think some of us are playing games with you!
If I take "do nothing , no change" to mean "DISPLAY nothing" then
=IF(H20,"Cancel","") where "" is a pair of quotes with nothing in between
(bit like my head sometimes)
Is 'peabody' a friend of 007
best wsihes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"peabody" wrote in message
...
Is it possible to have the program do nothing if the condition is false?
If H20,"cancelled",do nothing - no change to the current content of the
cell.