Great work Luke.
Works a treat.
Thanks a lot.
RR1

"Luke M" wrote:

We can adapt by instead checking to make sure 2 numbers are present:

=IF(COUNT(GB18,FC18)=2,GB18-FC18,"")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Romileyrunner1" wrote:

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