how to change rounding rules?

miaco11

New Member
Joined
Dec 6, 2004
Messages
11
The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5.

Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below.

E.g.
If value is 2.7, value will become 2
If value is 1.8, value will become 2

Thanks!
 

miaco11

New Member
Joined
Dec 6, 2004
Messages
11
Thank you so much for the reply Jon.

I actually used this since i expect 4 levels only (probably a longer way of computing it):

=IF(OR(C37="Sr. Supervisor",C37="Supervisor (Supervising)",C37="Supervisor (Non-supervising)"),LOOKUP(H37,{0,0.7,1.7,2.7,3.7},{"0","1","2","3","4"}),ROUND(H37,0))

=IF(OR(C37="Sr. Supervisor",C37="Supervisor (Supervising)",C37="Supervisor (Non-supervising)"),ROUND(H37-.3,0),ROUND(H37,0)) THIS IS PERFECT!!!

Thank you very much!
 

Forum statistics

Threads
1,082,441
Messages
5,365,539
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top