# Rounding Numbers

I have a Spreadsheet with multiple pages for quoting and pricing equipment.  It’s basically a program I setup with pricing so I can copy and paste.  When the quote is done I move the page to another book that contains all my other quotes.

I’m having a problem that only started happening three days ago.  In the spreadsheet I have a list price and multiply that by say .5 to get my cost and then take that cell which has two decimals and say divide by a 30% profit, =SUM(k22/.7) into another cell with no decimals(j22).  I then have a unit price using the formula into e22 using =j22 which has two decimals which are two zeros because j22 does not have decimals.

I would then move the sheet into another book like I mentioned earlier.  The problem is that all of a sudden when I move it the e22 cell is no longer two zeros, ex. it now reaads \$4,230.37

I did not change anything in my spreadsheet template.  It reads how I want it until I move it and again this only started happening a couple of days ago.

HELP!

DW

By: Dan West

### 10 thoughts on “Rounding Numbers”

1. ps4 games

Amazing! This blog looks just like my old one! It’s on a completely different subject but it has pretty much the same page layout and
design. Outstanding choice of colors!

2. quest bars cheap

I’m going to watch out for brussels. I’ll be grateful if you continue this
in future. Numerous people will be benefited from your writing.
Cheers!

3. ps4 games

An outstanding share! I have just forwarded this onto a
friend who has been doing a little homework on this.

And he actually ordered me dinner because I discovered it for him…

lol. So allow me to reword this…. Thank YOU for

4. ps4 games

When someone writes an post he/she maintains the thought of a user in his/her mind that how
a user can know it. Therefore that’s why this post is outstdanding.
Thanks!

5. quest bars cheap

You really make it appear really easy along with your presentation however I in finding
this topic to be actually one thing which I believe I would never understand.

It seems too complicated and extremely broad for me.
I’m looking forward to your subsequent submit, I’ll attempt
to get the cling of it!

6. quest bars cheap

I do not know if it’s just me or if everyone else experiencing issues with your site.
It seems like some of the text on your content are running off
the screen. Can somebody else please comment and let me know if
this is happening to them as well? This may be a issue with
my browser because I’ve had this happen before.
Many thanks

7. http://tinyurl.com/qrgqoyu

Hmm it seems like your website ate my first comment (it
was extremely long) so I guess I’ll just
sum it up what I wrote and say, I’m thoroughly enjoying your blog.
I too am an aspiring blog writer but I’m still new to the whole
thing. Do you have any points for beginner blog writers?

I’d really appreciate it.

8. tinyurl.com

Hi, i read your blog from time to time and i own a similar one and
i was just curious if you get a lot of spam remarks?
If so how do you prevent it, any plugin or anything you can suggest?
I get so much lately it’s driving me insane so any help is very much appreciated.