Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Range of Numbers
Hi there,
I have a column of numbers which I am looking to change. ie..all numbers between 1-10 should be replaced with a certain value and then all numbers between 11-20 with a different value etc...any assistance that you could provide would be greatly appreciated. Thanks, Pete |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Range of Numbers
Try this inserting what you want your values to be:
=IF(A1<1,A1,IF(A1<10,*New Value Here*,IF(A1<20,*New Value Here*,A1))) You can then (if you want) select all of your new values, copy, paste special as values to get rid of the equations. Hope it helps! -- -SA "Peter Herman" wrote: Hi there, I have a column of numbers which I am looking to change. ie..all numbers between 1-10 should be replaced with a certain value and then all numbers between 11-20 with a different value etc...any assistance that you could provide would be greatly appreciated. Thanks, Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replacing numbers in a cell | Excel Worksheet Functions | |||
Replacing Range Names | Excel Discussion (Misc queries) | |||
Replacing specific numbers | Excel Discussion (Misc queries) | |||
Replacing a random string of 5 numbers | Excel Discussion (Misc queries) | |||
using treater than and replacing numbers | Excel Worksheet Functions |