Microsoft Office Forums - View Single Post - ROUNDUP ONLY if > THAN A FIGURE

Thread: ROUNDUP ONLY if > THAN A FIGURE

View Single Post

Old

12-28-2016, 01:33 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Not sure this is entirely clear.

You want to Roundup only if a cell is greater than 3?

What do you want if the cell is less than 3?

=IF(A1>3,ROUNDUP(B1,0),B1)

Reply With Quote