Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |