Lowest multiplier for decimals

axeblade346

New Member
Joined
May 20, 2011
Messages
2
I have a spreadsheet with singular prices that have decimals and I am looking for a way to determan the Lowest multiplier to turn them into non decimal numbers

73c39b7a046a9254c3f917d2eab186cba67369e70eb9173c472c19bb3c0b911b6g.jpg


Lets take an example from the spreadsheet.
I sell a cobblestone for 20 coins and coal for 50 coins in the game this is for.
But 8 stone is made from "smelting" 8 cobblestone with coal and this my selling price for 1 stone will be 26.25. But the game has no 1/4 coins this I need to sell
4 Stone in a bundle for 105 coins. But what happens if Cobblestone price change how many stone must there in the bundle now?

Any ideas will be appreciated.

Thanks.
 
Last edited:

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I have played around with Nested if but I keep on getting the error of to many nested formulas with

IF(E9=TRUNC(E9),1,IF(E9*2=TRUNC(E9*2),2,IF(E9*3=TRUNC(E9*3),3,IF(E9*4=TRUNC(E9*4),4,IF(E9*5=TRUNC(E9*5),5,IF(E9*6=TRUNC(E9*6),6,IF(E9*7=TRUNC(E9*7),7,IF(E9*8=TRUNC(E9*8),8,More than 8))))))))

If 1 go over 8
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,275
Members
452,902
Latest member
Knuddeluff

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top