Forum Discussion
Solved
Find and Replace Range
Is it possible to use the find and replace feature to find a specific range of numbers between 0-100 in multiple rows/columns cells and replace it with a range value? For example if i had various num...
sirk78 you can use the IFS() statement:
=IFS(A1<=10,"1-10",A1<=20,"11-20",A1<=30,"21-30",A1<=40,"31-40", ... , A1<100,"91-100")or try this:
=MROUND(A1+4.99,10)-9 & " - " & MROUND(A1+4.99,10)which will work even past 100 but does assume 0.01 threshold (i.e. 10.001 will still fall under 1-10 instead of 11-20), but you can tweak that as you wish.
I had thought about nesting if statements but the values I am working with are 1-100 being grouped in ranges of 10 which would mean 10 if statements and my understanding is that the max is 7. Would this produce the same problem? Thanks
sirk78 you can use the IFS() statement:
=IFS(A1<=10,"1-10",A1<=20,"11-20",A1<=30,"21-30",A1<=40,"31-40", ... , A1<100,"91-100")or try this:
=MROUND(A1+4.99,10)-9 & " - " & MROUND(A1+4.99,10)which will work even past 100 but does assume 0.01 threshold (i.e. 10.001 will still fall under 1-10 instead of 11-20), but you can tweak that as you wish.