if false, do nothing

[peabody]

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

 

[shb]

Just type

=if(H2>0,"cancelled","")

The double quotes will return nothing for you.

 

[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)

 

[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
|
| | > Is it possible to have the program do nothing if the condition is false?
| > If H2>0,"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(H2>0,"Cancel","") where "" is a pair of quotes with nothing in between
(bit like my head sometimes)
Is 'peabody' a friend of 007
best wsihes