Thread: Return a value based on multiple criteria

I need to create a formula to return a value based on 3 criteria.

if A1 < 75 return "9" in B1
if A1 is between 75 & 95 return "3" in B1
if A1 is > 95 return "1" in B1

Thanks in advance.

Mike

=if(a1<75,9,if(a1>95,1,3))

Genius,

That works fine, many thanx