How do I Create a formula for greater or lesserthen

P

Put PPT to bed

How do I IF A1>C1 subtract A1 from C1 but IF A1<C1 subtract C1 from A1

A1 B1 C1 Toatal
15 30 15

A1 B1 C1 Total
30 15 30

I'm looking for the difference between one cell and another... Hope this
make sense.
 
B

Bob Phillips

=ABS(A1-C1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top