Hi all,
I'm trying to work out a formula so that if cell A1 has a number, it sees which range it falls in to and return a specific value. So in Cell A1 there will be a percentage and I'm looking for a formula to insert into B1 so if A1 has any of the ranges below, it should show either 25, 50 or 120 in B1
0% - 25% : 25
26% - 74% : 50
75% - 100% : 120
Does anyone know a formula I can insert that will show the value depending on the number?
Many thanks!
Bookmarks