View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rumy Rumy is offline
external usenet poster
 
Posts: 11
Default IF/OR/AND function in a formula

I have a unique scenario and need assiatance to create a formula.

I have dollar amounts in A,B,C,D,E,F columns. I need a result in G

it should be A+B+C. If A+B+C equals 0 the result should be D. If D also
equals 0 then the result should be E - F. Please help. Thanks.