Posted to microsoft.public.excel.newusers

Posts: n/a

rounding issues

I have a simple formula to multiple a cell with another and subtract
from another:=IF(K14<0,K14,IF(K17<K16,K14-K17*K15,K14-(K17*K15))) . I
also have the cell set for currency and two decimals over. The
calculations are automatically rounded up to the nearest $$. how can I
keep that from happening?

cheers

Day

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
Compatibility issues with macros (2000 vs. 2003)?	Lori Smith	Excel Discussion (Misc queries)	3	August 25th 05 08:10 PM
Rounding	LaraHubbs	Excel Discussion (Misc queries)	2	June 21st 05 09:42 PM
Rounding Issues	Louis	Excel Discussion (Misc queries)	1	February 4th 05 10:23 PM
Banker's Rounding - need help!	Somecallmejosh	Excel Discussion (Misc queries)	3	January 20th 05 09:53 PM
How do I make Excel stop rounding off my numbers that are 16 digi.	Aida	Excel Discussion (Misc queries)	1	December 6th 04 04:34 PM

All times are GMT +1. The time now is 05:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us