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.
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.
