mangesh_yadav

Posts: n/a

Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Mangesh

--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375528

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Addition problem, number always 2 cents off...Help	WTG	Excel Discussion (Misc queries)	3	March 30th 05 01:57 PM
Converting Text to Number	Andrew Bartholomew	Excel Discussion (Misc queries)	1	March 25th 05 02:50 AM
roundoff when converting text to numbers	Jack	Excel Worksheet Functions	3	January 30th 05 01:51 AM
Dollar Bill Chart	RJB1	Charts and Charting in Excel	2	January 7th 05 02:51 PM
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM

All times are GMT +1. The time now is 03:46 PM.

About Us

"It's about Microsoft Excel"