Math in Excel

[Nanaia]

Is there a way to create a formula that does the following...

If C2<47.5 then C2*(?) as long as the result doesn't exceed 95.1

I'm trying to maximize the number of parts from a sheet. Max sheet size is 48 wide (a set dimension) by 95 long (a variable dimension). I have a formula to calculate the number of pieces per width, but I'm trying to figure out how to incorporate something that will tell me if C2 is 47.5 or less I can get two on the length, if C2 is 15.75 I can get six on the length, but if C2 is 50 then since I can't get more than one piece out of 95, add 1 and display the result.

Am I out of my mind? Can this even be done? With all the brilliant minds I've encountered on here I'm hoping I can at least find out if what I want to do is possible.

I think this is more math than Excel, but as I'm wanting to use it in Excel I'm posting here hoping for help.

 

[wideboydixon]

=INT(95.1/C2)

Perhaps?

WBD

 

[Nanaia]

I got that to work. Any idea how to get it to add 1 to C2 if the number entered in that cell is over 95 and still keep the rest of the formula? Would that be an OR function?

Addendum: I added an IF function and think I got it to work.

Thank you so much for your help!