what if situations

Originally Posted by scayers

i am interested in a cell value based on multiple conditions.
if <=70 i want a value =0.25
if value is >70 but <=75 i want a value of 0.50
if value is >75 but <= 80 i want a value of 0.75

See if this is what you like

=if(and(A1>70,A1<=75),0.50,if(and(A1>75,A1<=80),0.75,if(A1>80,"Error",0.25)))

Originally Posted by scayers

BenjieLop -

Thanks, this is exactly what I needed. I would have never figured this out. Again, Thank You

scayers

Thank you for the feedback.