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