I have attached a fake spreadsheet to better explain.
If F2 displays no information (shows blank) , I need G2 to display no information (show blank).
The formula in column G is =IF(F2<=365,"1 year or less",(IF(AND(F2>=366,F2<=720),"2 years",(IF(AND(F2>=721,F2<=1095),"3 years",(IF(AND(F2>=1096,F2<=1460),"4 years",IF(F2>=1825,"5 years or more",""))))))))
I have tried =IF(ISBLANK(formula),"",formula). It still returns "5 years or more" in colum G, even if the referenced F cell is blank. I think my problem is that column F isn't really blank, it is just returning or displaying a blank cell based on the formula is column F.
Bookmarks