| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF statement result
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 |
|
#2
|
|||
|
|||
|
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 , TazzyDal 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...... |
|
#3
|
|||
|
|||
|
TazzyDal
=IF(A1="","",IF(A1=99%,"yes,"no")) Regards Trevor "TazzyDal" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
