=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b

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
 
L

Luke M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if(iserror()) question 2
Calculation / Format Error 1
Entereing an age and if statement in the same cell 1
To return a blank cell rather than 0% in a vlookup. 9
Zero if zero yet blank if blank? 5
vlookup 6
nested IF(OR Vlookup returning zero instead of value in target cel 7
Formula returning wrong answer 1

Top