Prev: Getting data from MS Access
Next: Look up with 2 colums and 3rows
From: Jim on 28 Jan 2010 13:15
Hello,

and thanks for hte help.

What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and,
return a balnk cell if B1 is blank?

Thanks
Jim
From: Eduardo on 28 Jan 2010 13:20
Hi,
If(B1="","","True")

I assumed blank if b1 is blank and true if it's other value

"Jim" wrote:

> Hello,
>
> and thanks for hte help.
>
> What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and,
> return a balnk cell if B1 is blank?
>
> Thanks
> Jim
From: Don Guillett on 28 Jan 2010 13:22
Look in the help index for IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Jim" <Jim(a)discussions.microsoft.com> wrote in message
news:FDDB71E6-29CB-4B61-B10A-37AE49430657(a)microsoft.com...
> Hello,
>
> and thanks for hte help.
>
> What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and,
> return a balnk cell if B1 is blank?
>
> Thanks
> Jim

From: Shane Devenshire on 28 Jan 2010 15:41
Hi,

Your question is incomplete - what if B1 is something other that 1 or blank?

If those are the only two choices, then try

=IF(B1=1,,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jim" wrote:

> Hello,
>
> and thanks for hte help.
>
> What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and,
> return a balnk cell if B1 is blank?
>
> Thanks
> Jim
 | 
Pages: 1
Prev: Getting data from MS Access
Next: Look up with 2 colums and 3rows