Hi Steve

touched confused here but does
=IF(G3D6,G3,MAX(G3+ABS(D2-D6),G3)

give you what you want?

actually the more i look at the question the less sure i am about what you
want
if D6 = 10 and D2 = 16 and G3 = 10 you want the formula to = 10
however
if "it?" do you mean G3 = 16 you want the formula to =16

so do you just want the the formula to = what is in G3?

maybe a few more examples will help.

Cheers
JulieD


"Steve" wrote in message
...
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