ExcelBanter - How do i place a roundup functoin at the end of a formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i place a roundup functoin at the end of a formula? (https://www.excelbanter.com/excel-worksheet-functions/111723-how-do-i-place-roundup-functoin-end-formula.html)

pyroblast

How do i place a roundup functoin at the end of a formula?

=G7*0.062 roundup(g7,2)

Dave F

How do i place a roundup functoin at the end of a formula?

=ROUNDUP(G7*.062,2)

Dave
--
Brevity is the soul of wit.

"pyroblast" wrote:

=G7*0.062 roundup(g7,2)

Pete_UK

How do i place a roundup functoin at the end of a formula?

Or does the OP mean:

=ROUNDUP(G7,2)*0.062

??

Pete

Dave F wrote:
=ROUNDUP(G7*.062,2)

Dave
--
Brevity is the soul of wit.

"pyroblast" wrote:

=G7*0.062 roundup(g7,2)

Dave F

How do i place a roundup functoin at the end of a formula?

Fair point. Ambiguity leads to confusion.
--
Brevity is the soul of wit.

"Pete_UK" wrote:

Or does the OP mean:

=ROUNDUP(G7,2)*0.062

??

Pete

Dave F wrote:
=ROUNDUP(G7*.062,2)

Dave
--
Brevity is the soul of wit.

"pyroblast" wrote:

=G7*0.062 roundup(g7,2)

All times are GMT +1. The time now is 08:33 AM.