Found a type-o. The desired formula should be:
if(g3d6,10,10+abs(D2-D6, 10).
"Steve" wrote:
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
|