If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

round to nearest .10

Overheal · 2009-08-12 13:54:18

Im probably missing something simple here This is spreadsheet not coding but we have no forum for excel :pac: My old formula was =(ROUNDUP((J2/0.5;0)*0.5)-0.01 Where J2 is a price. So if J2 was 4.64, this formula brings it up to 4.99. 4.34 to 4.49, etc. But i must be overlooking something simple, I want it to do it to the…

Options

12-08-2009 2:54pm

#1

Overheal

Registered Users Posts: 83,319 ✭✭✭✭

Join Date: September 2006

Posts: 76806

Im probably missing something simple here

This is spreadsheet not coding but we have no forum for excel :pac:

My old formula was

=(ROUNDUP((J2/0.5;0)*0.5)-0.01

Where J2 is a price. So if J2 was 4.64, this formula brings it up to 4.99. 4.34 to 4.49, etc.

But i must be overlooking something simple, I want it to do it to the nearest .10 so that 4.64 and 4.34 would become 4.69 and 4.39

0

Comments

Options
#2 12-08-2009 3:12pm
Overheal

Registered Users Posts: 83,319 ✭✭✭✭

Join Date: September 2006

Posts: 76806

nvm got it

=ROUNDUP(J2;1)-0.01

0