R
Romileyrunner1
Hi, using the following formula:
=IF(ISERROR(GB18-FC18),"",(GB18-FC18))
Problem is, if there is a blank cell in both a corresponding GB cell and FC
cell, then it is returning 0 (zero). Likewise, when there is just a value in
the GB cell e.g. 5.7, it is returning 5.7 as it is calling the blank cell as
a zero. In both cases, I want it to return a blank cell (hence ""), as I am
averaging the returning collumn and don`t want it to count blank cells as a
value of 0. (I just don`t want them included).
Hope this is clear guys (I`ve had a glass of wine!)
Thanks
RR1
=IF(ISERROR(GB18-FC18),"",(GB18-FC18))
Problem is, if there is a blank cell in both a corresponding GB cell and FC
cell, then it is returning 0 (zero). Likewise, when there is just a value in
the GB cell e.g. 5.7, it is returning 5.7 as it is calling the blank cell as
a zero. In both cases, I want it to return a blank cell (hence ""), as I am
averaging the returning collumn and don`t want it to count blank cells as a
value of 0. (I just don`t want them included).
Hope this is clear guys (I`ve had a glass of wine!)
Thanks
RR1