Thread: How do I Create a formula for greater or lesserthen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Put PPT to bed Put PPT to bed is offline
external usenet poster
  
Posts: 1
Default How do I Create a formula for greater or lesserthen
How do I IF A1C1 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.
Reply With QuoteReply With Quote