Simple If formula but can't get my head around it!

[Cheryl]

I have column A which has a score in it . In column B I have the formula:

=IF(A2>=326,"Pass","Fail")

This works ok but enters Fail even if there is no entry in column A. I want
to add to the formula the condition that if the cell is blank then the cell
in column B should also be blank.

I would be grateful for any help,

Thanks,

Cheryl

[Danny Lewis]

Hi Cheryl

=IF(A2="","",IF(A2>=326,"Pass","Fail"))

Danny

"Cheryl" wrote:

> I have column A which has a score in it . In column B I have the formula:
>
> =IF(A2>=326,"Pass","Fail")
>
> This works ok but enters Fail even if there is no entry in column A. I want
> to add to the formula the condition that if the cell is blank then the cell
> in column B should also be blank.
>
> I would be grateful for any help,
>
> Thanks,
>
> Cheryl

[CLR]

This will also check for TEXT in A2.........

=IF(OR(A2="",ISTEXT(A2)),"",IF(A2>=326,"Pass","Fail"))

Vaya con Dios,
Chuck, CABGx3




"Cheryl" wrote:

> I have column A which has a score in it . In column B I have the formula:
>
> =IF(A2>=326,"Pass","Fail")
>
> This works ok but enters Fail even if there is no entry in column A. I want
> to add to the formula the condition that if the cell is blank then the cell
> in column B should also be blank.
>
> I would be grateful for any help,
>
> Thanks,
>
> Cheryl

[Cheryl]

Thanks Danny, just what I wanted

Cheryl

"Danny Lewis" wrote:

> Hi Cheryl
>
> =IF(A2="","",IF(A2>=326,"Pass","Fail"))
>
> Danny
>
> "Cheryl" wrote:
>
> > I have column A which has a score in it . In column B I have the formula:
> >
> > =IF(A2>=326,"Pass","Fail")
> >
> > This works ok but enters Fail even if there is no entry in column A. I want
> > to add to the formula the condition that if the cell is blank then the cell
> > in column B should also be blank.
> >
> > I would be grateful for any help,
> >
> > Thanks,
> >
> > Cheryl

[Cheryl]

Thanks Danny, just what I wanted

Cheryl

"Danny Lewis" wrote:

> Hi Cheryl
>
> =IF(A2="","",IF(A2>=326,"Pass","Fail"))
>
> Danny
>
> "Cheryl" wrote:
>
> > I have column A which has a score in it . In column B I have the formula:
> >
> > =IF(A2>=326,"Pass","Fail")
> >
> > This works ok but enters Fail even if there is no entry in column A. I want
> > to add to the formula the condition that if the cell is blank then the cell
> > in column B should also be blank.
> >
> > I would be grateful for any help,
> >
> > Thanks,
> >
> > Cheryl

[Cheryl]

Thanks Danny, just what I wanted

Cheryl

"Danny Lewis" wrote:

> Hi Cheryl
>
> =IF(A2="","",IF(A2>=326,"Pass","Fail"))
>
> Danny
>
> "Cheryl" wrote:
>
> > I have column A which has a score in it . In column B I have the formula:
> >
> > =IF(A2>=326,"Pass","Fail")
> >
> > This works ok but enters Fail even if there is no entry in column A. I want
> > to add to the formula the condition that if the cell is blank then the cell
> > in column B should also be blank.
> >
> > I would be grateful for any help,
> >
> > Thanks,
> >
> > Cheryl