Limiting output based on cell data

[Darth yoda]

Hi gurus. I'm looking for a bit more help. I've got a worksheet that needs to be limited by the value in a cell. I've attached it so you can look at it and understand what I need better.
In I7 (red box) is a number that is the max a machine can rotate. B6 should never exceed this and B9 should be scaled down to match the output of B6. I think B9 will scale down automatically from the existing formulas if B6 is throttled correctly.
Should =FLOOR((((F5*D11)/D9)*3.82),50) have a max value equal to I7? And how would I incorporate it?

Thanks again guys, you have been extremely helpful.

Apparently I can't figure out how to attach my book. I need to limit the above formula to 8100. Thanks again.

Down at bottom of page it says I can't attach files.

 

[Joe4]

=FLOOR((((F5*D11)/D9)*3.82),50)
...
I need to limit the above formula to 8100

If you just want to limit the above formula to 8100, just use:
=MIN(FLOOR((((F5*D11)/D9)*3.82),50),8100)

BTW, we do not allow attachments on this site, but you can post screen images using the tools mentioned here: http://www.mrexcel.com/forum/about-board/508133-attachments.html
Alternatively, some people will upload files to file share sites and post the link here.