Round up formula Numbers

Maybe if you explained what value you're expecting...?

As written in your original post:

> ... divide the amount charged by my sample machinist (M) by $84 and then round up to the nearest $21 (N)

In your example, M73 contains the value $184.50

$184.5 divided by $84 is 2.1964285714

Neil's formula is rounding this up to 3, which is then multiplied by 21 for the result of 63, as noted.

What do you expect to see here?

Also worth clarifying what you mean by:

> then round up to the nearest 21

You can round up. You can round to nearest. Sometimes 'round to nearest' is the same as 'round up', but sometimes not... Technically, 2.1964285714 rounded 'to nearest' is 2, not 3.

The other interpretation of your question, based on the screenshot, is that $184.5 @$84/hour is ≈2.196 hours, and you want this number of hours rounded to the nearest 15 minute interval, but then I don't see where 21 comes in, other than as the rate for 1/4 hour at $84/hour.

So, again, what value are you trying to attain in the above example?

N72 = ROUNDUP(4×M72÷84,0)÷4

I recommend you plan ahead vs slowly increasing the scope.

One way would be

=IFS(A="Jane Stewart", formula for jane, A="Kate lastname", formula for kate, TRUE, formula for everyone else)

You will put that in the cell at the top of the column, in the first data row (not header), and it will spill into all the other rows. Or you can change each A to A2 (assuming the first data row is row 2) and then fill down with the formula manually.

If everyone except Jane has the same formula you can instead use

=IF(A="Jane Stewart", formula for jane, formula for everyone else)

If you are later going to be changing who has which formula or will be adding new people, you can use a new column to specify formula 1,2,3, etc for each to use. You would use that column instead of using names in the formula. If column C is the new column with the designator in it you can do something like this:

=IFS(C=1, formula for those who are 1, C=2, formula for those who are 2, C=3, formula for those who are 3)

Or you can use SWITCH

=SWITCH(C, 1, formula for 1, 2, formula for 2, 3, formula for 3)

or you can use CHOOSE

=CHOOSE(C, formula for 1, formula for 2, formula for 3)

If you use consecutive numbers (starting at 1) to designate which formula to use, CHOOSE is a concise option. If you use letters/text, SWITCH is a good option. If it is only going to be two formulas (one for Jane and one for everyone else), IF is a good option. IF and IFS are the most flexible options; you can create more complicate conditions.

Yeah, too much information. I don't know what else you have in mind so I gave you a few options.

Use one such as:

ROUNDUP(cell÷84,0)×21

(262353)