Posted to microsoft.public.excel.misc

DRB

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding numbers in a single cell	chefcasey	Excel Worksheet Functions	1	September 14th 05 06:51 AM
can a single cell contain multiple numbers?	jw446	Excel Worksheet Functions	5	August 10th 05 06:16 PM
macro help	thephoenix12	Excel Discussion (Misc queries)	4	July 15th 05 05:57 PM
Look for change next blank cell in Range	Nigel Bennett	Excel Worksheet Functions	1	March 13th 05 09:45 PM
occurance of numbers in cell range	Dillenger	Excel Worksheet Functions	14	February 21st 05 06:45 PM

All times are GMT +1. The time now is 08:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us