gabrielevery, try this, =ROUNDUP(A1*2.5,0)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gabrielevery"
wrote in message
news:gabrielevery.24zmkn_1142890803.7083@excelforu m-nospam.com...

and if i wanted to round that value up to the nearest whole number,
where would i put the ROUNDUP function


--
gabrielevery
------------------------------------------------------------------------
gabrielevery's Profile:
http://www.excelforum.com/member.php...o&userid=32650
View this thread: http://www.excelforum.com/showthread...hreadid=524530