View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default is there a way to write this function?

Here is basically what I want to write:

=if(G3 is the greater number of celss D6 & D2,abs(D2-D6, 10)
lets say 10 is in d6 and 16 is in d2. if g3 is 10, i want the formula result
to be 10. However if it is 16, i want the formula result to be 16. Due to the
variables, i can't write a simple if(g3d6,10,abs(D2-D6, 10).

I hope this isn't too confusing.

Thanks for any help you can offer,
Steve