Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to replace nos. below 100??
Hey folks,
am new to this forum. I have a 1000 X 100 spreadsheet with numbers on it. I would like to replace all the negative numbers with the value 5 and all postive numbers greater than 100 with the value 100. Is there a way I can do this quickly? Appreciate your ideas, Cricket |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
Find and Replace Formula Links | Excel Worksheet Functions | |||
Replace worksheet name in formula linked to a different workbook | Excel Discussion (Misc queries) | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |