How do I Create a formula for greater or lesserthen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=ABS(A1-C1)

--
HTH

Bob Phillips

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