Limiting output based on cell data

Darth yoda

New Member
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.

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
=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.

Replies
18
Views
689
Replies
5
Views
189
Replies
2
Views
384
Replies
3
Views
326
Replies
1
Views
710

1,202,977
Messages
6,052,887
Members
444,608
Latest member
Krunal_Shah

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back