Conditional Formula || IF AND HELP!!!

[investr]

If net margin is equal to or greater than 1.5% and less than 1.74% then commission is 6.0%, if margin is greater than or equal to 1.75% and less than 1.99% then commission is 6.5% and so on...

 

[Asala42]

Ok I think I follow you now

Where A2 = 95% (the listed goal) and B2 = the InputValue:

=IF(B2>=A2,100%,B2)

Should cover it,
Adam

 

[zacemmel]

So, you just want to return the corresponding value?

 

[investr]

All of my IM stuff is on if that is easier.

I need it to say all the different outcomes in one cell. Meaning if goal is < 95% then payout is 100% =>94 = 94, =>93 = 93 and on down the line

So more than just one outcome is what I am getting at...