remove "false"

[Suzanne Mead]

Is there a way to remove the word "false" from cells without
disturbing the formula? I need the cell to either be blank or to show
a "0".

 

[Mike A]

Is there a way to remove the word "false" from cells without
disturbing the formula? I need the cell to either be blank or to show
a "0".

Use Conditional Formatting (Format|Conditional Formatting...):

Create one condition - Cell value is Equal to "false"; click on
Format... and in the middle of the dialog, set the text color to white
(or whatever the background color is).

You can then use the format painter to copy this format to whichever
cells require it.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers

 

[Jim Cone]

Suzanne,

When you enter your formula enter the last argument as empty text: ""

=IF(A3 = C3,"Agree","")

Regards,
Jim Cone
San Francisco, CA

 

[Mike A]

Suzanne,

After reading Jim's post...

We don't know where the 'false' is coming from ... please post the
formula, it will help a lot.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers

 

[Suzanne Mead]

Suzanne,

After reading Jim's post...

We don't know where the 'false' is coming from ... please post the
formula, it will help a lot.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers

From Suzanne: I have a spreadsheet set up for billing tree removals
for a large contract. The trees get billed by size. One column is
set to enter a value if the size is between 1" and 30". The next
column i set up to enter a value if the size is between 31" and 70".
I don't like the fact that whatever column that doesn't get a value
entered shows the word false. Other than that the formula works for
me. I can't use the font the same color (white) to block this out
without going all through the spreadsheet & manually selecting those
cells, unless you can advise me of a way to do this. Example: a tree
is 24" diameter so the price (value) is entered in column #1, leaving
column #2 blank. I just don't want the word "false" in that cell.
Obviously I'm no expert at excel. Thanks for the use of your brains.

 

[Peo Sjoblom]

Post the formula itself, i.e select a cell that returns FALSE
and copy what's in it, then post it here

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Mike A]

I can't use the font the same color (white) to block this out
without going all through the spreadsheet & manually selecting those
cells, unless you can advise me of a way to do this.

If the conditional formatting works for you, except you don't want to
manually select the cells, you can try this if you want the formatting
applied to ALL formulas on your sheet. (The formatting will have no
effect unless a formula returns false.)

Press F5 on your keyboard. In the GoTo dialog, click 'Special...'.
Select Formulas. All cells in your sheet with formulas will be
selected. Now go to Format|Conditional Formatting... and set up the
formatting as I described in my first reply.

Please do this on a test copy of your file, rather than the only
working copy you have, to make sure that it will do what you want.

Once again, it REALLY helps us help you if you post information that
we ask for, like the formula that you are using. If you don't want to
post it, for whatever reason, that's okay, but we have to just guess
at what might work for you.


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers