Formula to show specific results?

  • Thread starter Thread starter OldKenGoat
  • Start date Start date
O

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
 
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
 
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
 
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
 
Back
Top