| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range of numbers in a single cell
I need to change what I multiple by based on the entered number.
If the entered number is 1 to 3, I need to multiply by .25 If the entered number is 4 to 6, I need to multiply by .5 If the entered number is 7 to 9, I need to multiply by .75 If the entered number is 10 to 12, I need to multiply by 1 and so forth. so if I enter 5 in A6, it will multiply 5 by .5 and put the result in A7 Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range of numbers in a single cell
=A1*(1+INT((A1-1)/3))/4
"DRB" wrote: I need to change what I multiple by based on the entered number. If the entered number is 1 to 3, I need to multiply by .25 If the entered number is 4 to 6, I need to multiply by .5 If the entered number is 7 to 9, I need to multiply by .75 If the entered number is 10 to 12, I need to multiply by 1 and so forth. so if I enter 5 in A6, it will multiply 5 by .5 and put the result in A7 Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range of numbers in a single cell
Very much thanks. You saved my sanity.
"Sloth" wrote: =A1*(1+INT((A1-1)/3))/4 "DRB" wrote: I need to change what I multiple by based on the entered number. If the entered number is 1 to 3, I need to multiply by .25 If the entered number is 4 to 6, I need to multiply by .5 If the entered number is 7 to 9, I need to multiply by .75 If the entered number is 10 to 12, I need to multiply by 1 and so forth. so if I enter 5 in A6, it will multiply 5 by .5 and put the result in A7 Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers in a single cell | Excel Worksheet Functions | |||
| can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
| macro help | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| occurance of numbers in cell range | Excel Worksheet Functions | |||
Linear Mode
