Again you should test:
To get just the integer part us =INT(A10)
(hope there are no neg numbers - if so replace INT by TRUNC)
To apply your rule
=INT(A10)+(MOD(A10,1)=INT(A10)*15%)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AmyTaylor" wrote
in message ...

Thank you very much, can you tell me how, using a formula, if I had the
figure 56.7 I could show the 56 portion only.
Then if the .7 was 15% of the 56 then it would round the 56.7 to 57,
otherwise it would stay at 56.

Thanks again.
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile:
http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=530023