View Single Post
  #1   Report Post  
Aileyan
 
Posts: n/a
Default Complex Conditional formulas

Need to know how to write a formula that combines several conditions. E.g:
IF(AND(E2<0,F2<0,E2<F2),(ABS(F2)-ABS(E2)),8) need to be combined with
IF(AND(E2<0,F20),(ABS(F2)-ABS(E2)) so that I get one result. How do I do
this?