ExcelBanter - Calculation divisble by three

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculation divisble by three (https://www.excelbanter.com/excel-discussion-misc-queries/52683-calculation-divisble-three.html)

CWH

Calculation divisble by three

I am using Office 2003

In Excel I am taking a number and multipling that figure by a %, is it then
possible to get the answer to be rounded up to be divisible by 3?

For example:

1000*20% = 200, I would like the answer to be 201
--
CWH

Bob Phillips

Calculation divisble by three

Rounded

=ROUND(1000*20%/3,0)*3

or rounded up

=CEILING(1000*20%,3)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"CWH" wrote in message
...
I am using Office 2003

In Excel I am taking a number and multipling that figure by a %, is it
then
possible to get the answer to be rounded up to be divisible by 3?

For example:

1000*20% = 200, I would like the answer to be 201
--
CWH

Stefi

Calculation divisble by three

Hi,

=(INT((1000*20%)/3)+1)*3

Regards,
Stefi

€žCWH€ ezt Ã*rta:

I am using Office 2003

In Excel I am taking a number and multipling that figure by a %, is it then
possible to get the answer to be rounded up to be divisible by 3?

For example:

1000*20% = 200, I would like the answer to be 201
--
CWH

All times are GMT +1. The time now is 11:09 AM.