if false, do nothing

P

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.
 
D

David Biddulph

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

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

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.
|
|
 
D

David Biddulph

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

Niek Otten said:
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)
Click to expand...
"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.
Click to expand...
 
B

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
 
Top