IF Formula to return a value based on another cell

[david1987]

Hi,

In A1 I always have a points total.

In B1 i sometimes have a value but sometimes I have an error, this value is based on a look-up table.

In C1 i want to calculate the total of A1+B1, however, if B1 is an error then I want to only calculate the total of A1.

Can anyone suggest a formula for this?

Thanks

David

[Søren Larsen]

Yes, try this:

Please Login or Register  to view this content.

[alansidman]

=iferror(A1 + B1,A1)

Alan

[Vinoth Kanna]

=(a1 + iferror(b1,0))