Page 8 of 8 FirstFirst ... 678
Results 71 to 73 of 73

Thread: Excel Sorcerers!

  1. #71
    Senior Member
    Join Date
    Jan 2014
    Location
    Sydney, Australia
    Posts
    2,108
    Good point!! Using formatting rather than modification.

    Using modifying if you need to operate on the data, eg round numbers, then sum. If you just want to display rounded, use formatting. But rounding before summing is different to summing then rounding.

  2. #72
    Junior Potato
    Join Date
    Jan 2014
    Posts
    8,522
    Yeah thanks for the suggestions. Unfortunately I canít do much rounding because Iím not sure what level of precision I need just yet. It depends on the task I guess.

    Plus Iíll need to rework some parts of it because I need the inverse equations too, and the molarity section is completely backwards and not user-friendly!

  3. #73
    Senior Member
    Join Date
    Jan 2014
    Location
    Cambridge, UK
    Posts
    750
    Thought I'd quickly knock up what I was thinking:

    https://docs.google.com/spreadsheets...N1o/edit#gid=0



    The formulas for the green cells are just either B / C or B x C, as appropriate, and then formatted as number or percentage as needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •