"If "Formula
 

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

=IF(A1<=14,A1*.5,((14*.5)+((A1-14)*1)))

"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

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

Sometimes it's easier to create another column. Example:
Column A has the information
Create a formula in Column B If(cell a1 =14,1,0)
Create a formula in Column C If(cell b1 =1,Cell A1 *.5,Cell a1 *1)
You should be able to do this formula in one cell
If(a1<15,A1*.5,a1*1)
try both ways
Any way to get the end result is correct. If you c reate extra cells you can
always hide the column after. Good luck!!!!

"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