Thread: plus and minus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default plus and minus

good day.
I need a formula for the following
A B C D E F G H
I
100 0 10 110 0
100 0 90 0 0
100 100 10 90 100
For column F, I need (if the total of C,D,E are bigger than A - B it should
show A.
For column G, I need (if the total of C,D,E are bigger than A - H it should
show C,D,E - A
For column H, I need (if the total of C,D,E are smaller than A - B it should
give the total

thanks