IF statement result

[TazzyDal]

I have an IF statement that is as follows:

=if(a1=99%,"yes,"no")

What I would like to see is if cell a1 is blank, then neither "yes" or
no" are returned, the cell would remain blank......


--
TazzyDal

[JE McGimpsey]

One way:

=IF(A1="","",IF(A1=99%,"yes","no"))

The formula will return a null string, which displays as if the cell
were blank.


In article <[email protected]>,
TazzyDal <[email protected]> wrote:

> I have an IF statement that is as follows:
>
> =if(a1=99%,"yes,"no")
>
> What I would like to see is if cell a1 is blank, then neither "yes" or
> no" are returned, the cell would remain blank......

[Trevor Shuttleworth]

TazzyDal

=IF(A1="","",IF(A1=99%,"yes,"no"))

Regards

Trevor


"TazzyDal" <[email protected]> wrote in message
news:[email protected]...
>
> I have an IF statement that is as follows:
>
> =if(a1=99%,"yes,"no")
>
> What I would like to see is if cell a1 is blank, then neither "yes" or
> no" are returned, the cell would remain blank......
>
>
> --
> TazzyDal