| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Balnk cells
Hi
Any help I have a cell resulting from an IF function, the result is either a number or blank (“”). I want to write If function in the next cell for IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when number is in the cell, I want another condition that if the cell is blank (“”), the result will be “notpass”, is there anyway to recognize the (“”). Thanks in advance Jam |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Balnk cells
To make sure
=if(len(trim(ae11))<1,"really blank","someone touched the space bar") -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... Hi Any help I have a cell resulting from an IF function, the result is either a number or blank (“”). I want to write If function in the next cell for IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when number is in the cell, I want another condition that if the cell is blank (“”), the result will be “notpass”, is there anyway to recognize the (“”). Thanks in advance Jam |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Balnk cells
try this
=IF(AND(AE110,AE11<=3),"pass",IF(OR(AE11="",AE11= 0),"notpas","fine")) On Oct 2, 7:09*pm, wrote: Hi Any help I have a cell resulting from an IF function, the result is either a number or blank (“”). I want to write If function in the next cell for IF(AND(0AE11<=3);"pass";IF(AE11=0;"notpas";"fine" )), this work when number is in the cell, I want another condition that if the cell is blank (“”), the result will be “notpass”, is there anyway to recognize the (“”). Thanks in advance Jam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| How can I delete all balnk cells in a column? | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| How can I copy information from one column, but not balnk cells? | Excel Discussion (Misc queries) | |||
Linear Mode
