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

Thread: Excel Sorcerers!

  1. December 5th, 2021, 01:41 PM #71
    Dicknose
    Dicknose is offline
    Senior Member
    Join Date
    Jan 2014
    Location
    Sydney, Australia
    Posts
    2,026
    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.
    Reply With Quote Reply With Quote
  2. December 5th, 2021, 09:34 PM #72
    Rare White Ape
    Rare White Ape is offline
    Junior Potato
    Join Date
    Jan 2014
    Posts
    8,317
    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!
    Reply With Quote Reply With Quote
  3. December 6th, 2021, 10:42 AM #73
    samoht
    samoht is offline
    Senior Member
    Join Date
    Jan 2014
    Location
    Cambridge, UK
    Posts
    705
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules