Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a way to repeat a formula pattern within a cell
I'm looking for a way to get this formula to continue on changing value every
10 numbers but only increasing 2 numbers in the result. =IF(C7<=19,"4",IF(C7<=29,"6",IF(C7<=39,"8",IF(C7<= 49,"10",IF(C7<=59,"12",IF(C7<=69,"14",IF(C7<=79,"1 6",IF(C7<=89,"18",)))))))) I need an expert in writing code |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a way to repeat a formula pattern within a cell
Hi dla,
will u try this formula? =2*(LEFT(C1,IF(LEN(C1)=1,1,LEN(C1)-1))+1) the difference from your sample is if C7=0, answer here is 2... assume all positive numbers on C7 only regards -- ***** birds of the same feather flock together.. "dla" wrote: I'm looking for a way to get this formula to continue on changing value every 10 numbers but only increasing 2 numbers in the result. =IF(C7<=19,"4",IF(C7<=29,"6",IF(C7<=39,"8",IF(C7<= 49,"10",IF(C7<=59,"12",IF(C7<=69,"14",IF(C7<=79,"1 6",IF(C7<=89,"18",)))))))) I need an expert in writing code |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a way to repeat a formula pattern within a cell
Try =4+2*CEILING((MAX(C7-19,0)/10),1)
Did you actually want text strings (as you've put the numbers in quotes)? I've assumed you probably wanted real numbers? -- David Biddulph "dla" wrote in message ... I'm looking for a way to get this formula to continue on changing value every 10 numbers but only increasing 2 numbers in the result. =IF(C7<=19,"4",IF(C7<=29,"6",IF(C7<=39,"8",IF(C7<= 49,"10",IF(C7<=59,"12",IF(C7<=69,"14",IF(C7<=79,"1 6",IF(C7<=89,"18",)))))))) I need an expert in writing code |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
looking for a way to repeat a formula pattern within a cell
Have you tested your formula with values like 2, 3, 4, 5, 6, 7, 8 and 9 respectively in C1?
Epinn "driller" wrote in message ... Hi dla, will u try this formula? =2*(LEFT(C1,IF(LEN(C1)=1,1,LEN(C1)-1))+1) the difference from your sample is if C7=0, answer here is 2... assume all positive numbers on C7 only regards -- ***** birds of the same feather flock together.. "dla" wrote: I'm looking for a way to get this formula to continue on changing value every 10 numbers but only increasing 2 numbers in the result. =IF(C7<=19,"4",IF(C7<=29,"6",IF(C7<=39,"8",IF(C7<= 49,"10",IF(C7<=59,"12",IF(C7<=69,"14",IF(C7<=79,"1 6",IF(C7<=89,"18",)))))))) I need an expert in writing code |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Colors | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |