I've had a bit of a search and haven't been able to find anything relating to what I need to do.
Is there a way of creating a sum or vlookup formula that will consider any #N/A value returned as a zero? For instance:
=SUM(C2:C3)
Can I produce a result of zero (or 3, for arguments sake, if C2=#N/A and C3=3) if either or both cells contain an #N/A?
Alternatively:
=VLOOKUP($A2,Workings!$E:$M,2,FALSE)
Is there a way of returning a zero value (as opposed to #N/A) if the value in A2 doesn't appear within the defined range (ie Workings!E:M)?
I realise that a simple sum or vlookup formula will not do this but am hopeful that there may be an alternative.
Nick
Is there a way of creating a sum or vlookup formula that will consider any #N/A value returned as a zero? For instance:
=SUM(C2:C3)
Can I produce a result of zero (or 3, for arguments sake, if C2=#N/A and C3=3) if either or both cells contain an #N/A?
Alternatively:
=VLOOKUP($A2,Workings!$E:$M,2,FALSE)
Is there a way of returning a zero value (as opposed to #N/A) if the value in A2 doesn't appear within the defined range (ie Workings!E:M)?
I realise that a simple sum or vlookup formula will not do this but am hopeful that there may be an alternative.
Nick