Okay so I have a conditional format that is very simple:
=C5>=(30*0.85)
If this is true then the cell is supposed to turn red. Which for the most part works fine.
This was my original formula within the cell itself:
=AVERAGE(AI8:BF8)/2
This also works well for the most part unless there is no numbers within the range yet. It will return a #DIV/0! in that case.
So I switched to a new formula:
=IFERROR(AVERAGE(AI7:BF7)/2,"")
This also works well for the most part except for the same scenario where there are no numbers in the range yet. It is turning the cell red which means that the value should be >=(30*0.85), which it is not. The value should be "" or blank. I even tried using "0" instead and it still turns red. Any ideas?
Bookmarks