Limiting the output value of an IF formula?

[Oberst Hajj]

Hello everyone, looking for a little Excel help from the smarter people!

How do I modify the formula:

=IF(B8="Straight",3+C7,-4+C7)

So that the max value returned is 8 and the min value returned is 0?

 

[Comfy]

=IF(B8="Straight",IF(3+C7>8,8,IF(3+C7<0,0,3+C7)),IF(-4+C7>8,8,IF(-4+C7<0,0,-4+C7)))

 

[Weaver]

TRY

=MIN(8,MAX(0,IF(B8="Straight",3+C7,-4+C7)))

 

[Oberst Hajj]

Thanks guys! They both worked, but Weaver's was a little easier/flexible for what I was wanting to try and do.

 

[Weaver]

Thanks for the feedback. Good luck with your project!