Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
6206 Online
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
AR15.COM
bravocompany
My Account
bravocompany bravocompany bravocompany
brownells brownells
tnvc tnvc tnvc
palmetto
colt
Guns
GS
skd
springfield
JRH
silencerShop
OSIGHT
vortex
cz
bravocompany
fightlite
aim
brownells
midwest
DFC
geissele
primaryArms
magpul
RS
Holosun
6206 Online
cz
RS
Guns
bravocompany
aim
fightlite
geissele
JRH
brownells
silencerShop
midwest
vortex
primaryArms
palmetto
GS
Holosun
skd
magpul
OSIGHT
DFC
colt
springfield
Site News Could You Have Stopped This? Vegas Shooting Analysis with Attorneys on Retainer
Sponsor News Introducing TNVC's NEW and Exclusive Filmed SuperGain (FSG) and Chimera Panoramic Goggle Giveaway!
2/19/2007 2:44:11 PM EDT
I want to round a cell with an existing formula in it.

this is the formula:   =+'Revenue Projection'!M1  and it shows as $8,541,403 (it is a result from another sheet)

I want to round that in the same cell to the nearest $1000 ($8,541,000)

Anybody know how to get this done?
2/19/2007 2:48:13 PM EDT
[#1]
RTFM

pretty sure the command is round  (RND)
or truncate

2/19/2007 2:50:10 PM EDT
[#2]
You cannot round a cell.  They are rectangles, or sometimes squares.
2/19/2007 2:53:32 PM EDT
[#3]
Format --> cells --> number --> (under category) number --> set the decimal places to whatever significant number you wish to round to
2/19/2007 3:17:28 PM EDT
[#4]
the command is "round". I just can't figure out how to round a cell with a formula in it. If it was just a number it would be easy. The cell is B51 so the formula (in a different cell) would be

=ROUND(B51,-3)
2/19/2007 4:19:47 PM EDT
[#5]
=ROUND(+'Revenue Projection'!M1, -3)
2/19/2007 4:28:40 PM EDT
[#6]

Quoted:
=ROUND(+'Revenue Projection'!M1, -3)


=ROUND('Revenue Projection'!M1,-3) Result I got from another board, I'm sure yours would work also.

Thank you very much! I spent a lot of time trying to figure that one out.
2/19/2007 4:35:00 PM EDT
[#7]
How do you make a + show for positive numbers?
2/19/2007 4:58:48 PM EDT
[#8]
I was wondering what the '+' sign was there for anyway.  It didn't make any difference either way.


Quoted:
How do you make a + show for positive numbers?


You can do it in code or formatting.  For formatting the order goes:
positive;negative;zero;text;

The following formatting does whole dollars, positive with a leading '+', negative red with a leading '-'.


+$#,##0_);-$#,##0_)
2/19/2007 5:18:42 PM EDT
[#9]
I've never figured out how to round like that.  

I just use scientific notation, i.e.:

8.541E+06
2/20/2007 1:26:11 AM EDT
[#10]

Quoted:
I was wondering what the '+' sign was there for anyway.  It didn't make any difference either way.



[cough,cough] My old "Lotus" history creeping in to Excel....[cough]
springfield
fightlite
geissele
bravocompany
palmetto
gray
LAPG
blackhills
Faxxon
ar15com
LAPG
CA
silencerShop
RS
cmmg
colt
brownells
THBRD
SAS
ar15com
Pro2A
primaryArms