Calculation divisble by three

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

Hi,

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

Regards,
Stefi


„CWH†ezt írta: