if cell b7 <100000, then I want to return a value of 0 in cell c7 if cell b7 is >=100000, <250000, then I want to return a value of .5 in cell c7 if cell b7 >=250000, <500000, then I want to return a value of .75 in cell c7 if cell b7 >=500000, then I wan to return a value of 1.00 in cell c7
Solved by D. U. in 23 mins