How to keep a cell empty at the same time formula embedded?

C

CLR

A cell cannot be both "empty" and contain something...........you can
however, put a formula there that will display a blank cell according to the
conditions of it's calculations...........

=(IF(A1>5,A1,"")......will display a blank cell if A1 is 5 or less

Vaya con Dios,
Chuck, CABGx3
 
J

JE McGimpsey

What are you really trying to do?

A cell can contain either an entered value or a formula, but not both.
However, there are ways using VBA to work around that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Embed the same Excel multiple times 0
Autonumber field in Excel that behaves the same as Access 0
Nested if then statement 2
Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Excel does not accept text format! 0
Custum Cell Format - display 0 (zero) when cell is empty 8
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Top