I have attached an excel in which I find difficulty in keeping the Status output blank if there is no data needed or if the loop cell is blank.
Need your support in this regard. Thank you....
Appreciated
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Blank Cell Query
0
Answers
0
Selected Answer
You could just nest another IF statement in your formula to check that column O doesn't contain a blank. E.g. for cell P10 make it read (changes in bold below):
=IF(AND(O10>0,O10<=30),$J$3,IF(O10<=0,$E$3,IF(O10<>"",$N$3,"")))Then copy to other cell in that column.
Hope this helps.