Round the calculation result ignoring the integer

[DeniseL]

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

 

[mvptomlinson]

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]

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

 

[DeniseL]

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