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
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
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......
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks