On Wed, 6 Apr 2005 08:15:03 -0700, "tojo107"
wrote:
A
1 10
2 17
Want formula for cell b1 that will look at A1, if <= 14, then A1*.5 . If
A1 is =15, then it would multiply the first 14*.5, then from 15 on up
multiply by 1.
Thanks,
Tom
=0.5*(A1+MAX(0,A1-14))
--ron
|