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.



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

    Hello there, just became alert to your blog through Google, and found that it’s truly informative.

    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.

  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
    the meal!! But yeah, thanx for spending time to talk about this subject
    here on your internet site.

  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.

  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


    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.


    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.

Comments are closed.