LinkBack URL
About LinkBacksHi, My mum needs to know how to round to thousands in excel for work. For example, financial accounts are often rounded to thousands e.g £6000 would be shown as £6. Is there any command or formula that will do this, thanks. John.l
Rounding to thousands in Excel?
Hi, My mum needs to know how to round to thousands in excel for work. For example, financial accounts are often rounded to thousands e.g £6000 would be shown as £6. Is there any command or formula that will do this, thanks. John.l
Cheiftech Matrix/xp 2600@ 2.3ghz/ Abit NF7 v2/1gb GEIL value dual channel pc3200@ 2.5-3-3-6/XFX 6600gt/80gb Western Digital boot disk/80gb maxtor for storage and games/LG cdrw/Nec 3500A
one way is to int(A1/1000) - that will get you the number of complete 1000s
or round(A1/1000,0) - that will round £5500 up to 6
If you want to split it then thousands: int(A1/1000) and rest: A1 MOD 1000 are the tools you need
GK
Keeper of the Gates of Hell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote