Formula to show specific results?

[OldKenGoat]

I know the answer to this is something simple, but it has me stumped. I need
a formula in C4 which, when copied to the remaining cells in Col C, will
show the listed results.

A B C
1 4 0 4
2 3 -2 5
3 -1 -3 2
4 -2 2 0

TIA,

OldKenGoat

 

[Bernard Liengme]

Looks like homework? But you pen name belies this idea!
Surely you can see that:
4 - 0 = 4
2-(-3) = 5
-1-(-3) =2
-2 -2 = 0
So in C4 enter =A4-B4
OR in C1 use =A1=B1

best wishes
Bernard

 

[RagDyer]

This works for 3 out of the 4 rows.
=A1-B1

Is the result you posted for row 4 a typo, or is that what you're really
looking for?

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I know the answer to this is something simple, but it has me stumped. I need
a formula in C4 which, when copied to the remaining cells in Col C, will
show the listed results.

A B C
1 4 0 4
2 3 -2 5
3 -1 -3 2
4 -2 2 0

TIA,

OldKenGoat

 

[Sandy Mann]

If it is not a typo how about:

=A1+SIGN(B1)*B1

Sandy

 

[Ken Wright]

Bernard, you may want to reconsider your last one there (the one with the 2s)

 

[Ken Wright]

How about in C1:-

=A1+ABS(B1)

and copy down

or in C4

=A4+ABS(B4)

and copy up <g>

 

[OldKenGoat]

Thanks, Sandy! That's exactly what I needed. I'd forgotten all about the
SIGN function! And thanks also to all the others who replied.
OldKenGoat