"False"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keyrookie - 17 Sep 2007 16:26 GMT

How do you remove the "FALSE" value in a cell. The formula I'm using i
simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have
"p".

Help please,

Keyrooki

--
Keyrookie

Reply to this Message

Peo Sjoblom - 17 Sep 2007 19:45 GMT

So what do you want it to return? Blank?

=IF(I7="p",G7,"")

Signature

Regards,

Peo Sjoblom

> How do you remove the "FALSE" value in a cell. The formula I'm using is
> simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a
[quoted text clipped - 3 lines]
>
> Keyrookie

Reply to this Message

Dave Peterson - 17 Sep 2007 19:47 GMT

=if(i7="p",g7,"whatdoyouwantinstead")
or
=if(i7="p",g7,"")
to make it look blank

> How do you remove the "FALSE" value in a cell. The formula I'm using is
> simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a
[quoted text clipped - 6 lines]
> --
> Keyrookie

Signature

Dave Peterson

Reply to this Message

Sandy Mann - 17 Sep 2007 19:49 GMT

=IF(I7="p",G7,"")

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> How do you remove the "FALSE" value in a cell. The formula I'm using is
> simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a
[quoted text clipped - 3 lines]
>
> Keyrookie

Reply to this Message