S
Sally
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?
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?