Excel Equation Help

1

Hello everyone so this is off topic from x-carve but relates to a cnc machine and a cnc business lol

and I am hoping that someone is familiar with Mircosoft Excel (I am using Excel 2010)

Here is the long version of the equation I need and I need to formulate this into 1 cell so it will calculate the correct number

qty sold ( # is in cell B6) / parts per sheet (7) = number of sheets (then I need to take this number and round up to the nearest whole number ex: 3.57 should = 4 always needs to round up the number not round down)

then

288 x # of sheets (we got this number from above) x 0.008 = the number I am looking for

Example : qty 25 / 7= 3.57 (round up) = 4 sheets of material

288 x 4 = 1152 x 0.008 = 9.216

would anyone be able to help out with this ??

thanks

2

Try this for the first part:

=(ROUNDUP(((B6)/7),0))

3

@ErikJenkins

yup that worked to get me a 4!

how do I incorporate the second part into it?

4

Calc.xlsx (9.0 KB)

5

What exactly are you doing for the second part…a little confused…

6

Nice job…you beat me to it…lol

1 Like
7

@LarryM

thank you for that but how do I get all that contained in one cell? as I have many cells that I need that same equation in but the input numbers will be different

@ErikJenkins

so for the second part I need to take that number I got in the first equation and incorporate it into the second equation

288 x 4(the number from the first equation) x 0.008 = my final number

and I need this all contained within 1 cell

8

Are you going to copy the function to multiple cells?

9

yes I will but I will need to change some numbers like the qty and the 1152 and the 7

10

=(ROUNDUP(((B6)/7),0)2880.008)

but you will have to change it when you use it with something else

EDIT: the asterix does not work on this forum…replace the X with an asterix:

=(ROUNDUP(((B6)/7),0)X288X0.008)

11

@ErikJenkins

your a GOD

thank you lol

this is why I need a accountant lol

because I want to create these spreadsheet to keep track of my numbers

you don’t do any estimating or accounting on the side do you?

1 Like
12

Glad it worked…and no accounting work for me…lol

13

you just learned Excel as a side hustle lol I gotcha

no worries thanks for the excel equation

1 Like
16

yeah but I am needing this all contained in 1 cell there would be no cell with the X1 value

17

HEY!! you all are supposed to be woodworking geeks!!

…just kidding!

18

At least you didn’t say “nerd”. :smiley: