Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells in Excel
The following formula is in cell F66 =IF(E66<=13,L66,IF(AND(E6613,E66<18),"",M66)) Thank you to John Moore for this formula. This allows me to place text stored in cell L66 into cell F66 if the value in cell E66 is <13, and text stored in cell M66 if the value in E66 is 18. Cell E66 is blank if the value is between 13 and 18. I would like to alter this formula so that all of the above does not change, but if nothing is entered into E66 then cell F66 is also blank. As it stands now if no value is entered into E66, then F66 defaults to the text from L66. I saw an ISBLANK function that looked interesting but dont know how to incorporate it into this formula without losing what I already have. Thank you. Danny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells in Excel
How about:
=IF(E66="","",IF(E66<=13,L66,IF(AND(E6613,E66<18) ,"",M66))) I used =if(e66="",... But I could have used: =if(isblank(e66),... Danny wrote: The following formula is in cell F66 =IF(E66<=13,L66,IF(AND(E6613,E66<18),"",M66)) Thank you to John Moore for this formula. This allows me to place text stored in cell L66 into cell F66 if the value in cell E66 is <13, and text stored in cell M66 if the value in E66 is 18. Cell E66 is blank if the value is between 13 and 18. I would like to alter this formula so that all of the above does not change, but if nothing is entered into E66 then cell F66 is also blank. As it stands now if no value is entered into E66, then F66 defaults to the text from L66. I saw an ISBLANK function that looked interesting but dont know how to incorporate it into this formula without losing what I already have. Thank you. Danny -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells in Excel
"Danny" wrote:
I saw an ISBLANK function that looked interesting but dont know how to incorporate it into this formula without losing what I already have. I would not use ISBLANK(). That is true only if there is no formula and no value (like "") in the cell. If you want to distinguish between empty and appearing blank due a null string, ISBLANK is the right choice. But I suspect you want F66 to be "" if E66 __appears__ blank, be it empty or because it contains "". In that case: =if(E66="", "", if(E66<=13, L66, if(E66<18, "", M66))) ----- original message ----- "Danny" wrote in message ... The following formula is in cell F66 =IF(E66<=13,L66,IF(AND(E6613,E66<18),"",M66)) Thank you to John Moore for this formula. This allows me to place text stored in cell L66 into cell F66 if the value in cell E66 is <13, and text stored in cell M66 if the value in E66 is 18. Cell E66 is blank if the value is between 13 and 18. I would like to alter this formula so that all of the above does not change, but if nothing is entered into E66 then cell F66 is also blank. As it stands now if no value is entered into E66, then F66 defaults to the text from L66. I saw an ISBLANK function that looked interesting but dont know how to incorporate it into this formula without losing what I already have. Thank you. Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) |