Hi
I have the following formula for averaging cells or just bring back a number from one cell ...
=IF(AND(BK5="",BU5=""),"",IF(AND(BK5<>"",BU5<>""),AVERAGE(BK5,BU5),IF(BK5="",BU5,IF(BU5="",BK5))))
This works if the cells have blanks in them, but i also need it to do similar if any of the...