How to write a formula to round up and/or down
 

Do you know how to write a formula to round up and/or down?

My situation is:

Hours x % to one employee (different pay rate)
Hours x % to another employee (different pay rate)


For example,

It takes 22 Hours to perform Coordination on a certain project
85% goes to the Project Engineer
15% goes to clerical
My goal is to determine how many of the 22 hours go to the Project Engineer
and how many go to clerical.

85% x 22 = 18.7
15% x 22 = 3.3

Now we have to round-up or round-down to the nearest .25 because our hours
are recorded in .25 increments.
I want the 18.7 to be 18.75 and the 3.3 to be 3.25

I know how to make the formula round up, but I don't know how to tell the
formula to go up or down depending on the situation.

Can you help?

How to write a formula to round up and/or down
 

Try these:

A1 = 22

=ROUND((A1*0.85)/0.25,0)*0.25

=ROUND((A1*0.15)/0.25,0)*0.25

--
Biff
Microsoft Excel MVP


"Sally" wrote in message
...
Do you know how to write a formula to round up and/or down?

My situation is:

Hours x % to one employee (different pay rate)
Hours x % to another employee (different pay rate)


For example,

It takes 22 Hours to perform Coordination on a certain project
85% goes to the Project Engineer
15% goes to clerical
My goal is to determine how many of the 22 hours go to the Project
Engineer
and how many go to clerical.

85% x 22 = 18.7
15% x 22 = 3.3

Now we have to round-up or round-down to the nearest .25 because our hours
are recorded in .25 increments.
I want the 18.7 to be 18.75 and the 3.3 to be 3.25

I know how to make the formula round up, but I don't know how to tell the
formula to go up or down depending on the situation.

Can you help?

How to write a formula to round up and/or down
 

=MROUND(your_formula,0.25)
If you get a #NAME? error, check Excel help for the MROUND function.
--
David Biddulph

"Sally" wrote in message
...
Do you know how to write a formula to round up and/or down?

My situation is:

Hours x % to one employee (different pay rate)
Hours x % to another employee (different pay rate)


For example,

It takes 22 Hours to perform Coordination on a certain project
85% goes to the Project Engineer
15% goes to clerical
My goal is to determine how many of the 22 hours go to the Project
Engineer
and how many go to clerical.

85% x 22 = 18.7
15% x 22 = 3.3

Now we have to round-up or round-down to the nearest .25 because our hours
are recorded in .25 increments.
I want the 18.7 to be 18.75 and the 3.3 to be 3.25

I know how to make the formula round up, but I don't know how to tell the
formula to go up or down depending on the situation.

Can you help?