Roundup If Formula

M Welsh

New Member
Joined
Mar 7, 2015
Messages
20
I am looking to roundup if the number in a cell ends higher than 0.2 and round down if its lower than 0.2 so for example 1.2 would round to 2 and 1.1 would round down to 1. Have tried everything with ROUNDUP and IF but can't work it out.

Any help much appreciated :)
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Re: Help Needed with Roundup If Formula Please....

=round(a1+0.3,0)
 

M Welsh

New Member
Joined
Mar 7, 2015
Messages
20
Re: Help Needed with Roundup If Formula Please....

Scott Huish,

That works really well and so simple - thanks very much. :)

Michael
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top