# Round the calculation result ignoring the integer

#### DeniseL

##### New Member
Can someone please help me correct my following formula so that it rounds only on the decimals, not on the integer. As it is now, '>=0.51' looks at the entire number and I need it to only look at the decimals.

=IF(CH8<>2,"",IF((CE8/3)-(CF8/3*2)>=0.51,ROUNDDOWN((CE8/3)-(CF8/3*2),0),ROUNDUP((CE8/3)-(CF8/3*2),0)))

Thanks in advance for any help.
DeniseL

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### mvptomlinson

##### Well-known Member
If I'm understanding you correctly, perhaps:

=IF(CH8<>2,"",IF((CE8/3)-(CF8/3*2)-INT((CE8/3)-(CF8/3*2))>=0.51,ROUNDDOWN((CE8/3)-(CF8/3*2),0),ROUNDUP((CE8/3)-(CF8/3*2),0)))

#### DeniseL

##### New Member
Thank you so much, mvptomlinson, I'll try it and let you know the outcome.
DeniseL

#### DeniseL

##### New Member
for mvptomlinson absolutely perfect, it did exactly what I needed it to do. Many thanks. DeniseL

Replies
3
Views
122
Replies
2
Views
119
Replies
4
Views
250
Replies
3
Views
318
Replies
4
Views
392

1,191,671
Messages
5,987,958
Members
440,122
Latest member
branhill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back