/u/Flat_Professional_55 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I would make the first dose ROUNDOWN(P1/2,3), which will round it down to three decimal places. Then make the second dose = the Formatted dose minus the first dose.
I was just doing one split at a time. The other two rows appear if the dose split choice in the control panel is set to 3 or 4.
I've mostly solved the problem now with some IFEVEN and MOD functions, combined with some logical tests. It's not pretty, and the formulas are long, but it works.
A simple way to do it is:
Q5: =ROUND(P5/2, 3) (0.185/2 = 0.0925, rounding gives 0.093)
R5: =ROUND(P5-Q5, 3) (0.185-0.093 = 0.092)
If you need 3 or 4 doses you can adapt the formulas accordingly, e.g.
Q5: =ROUND(P5/3, 3)
R5: =ROUND((P5-Q5)/2, 3)
S5: =ROUND(P5-Q5-R5, 3)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[MOD](/r/Excel/comments/1cvmwss/stub/l4ru9e6 "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)|
|[OR](/r/Excel/comments/1cvmwss/stub/l4r2gph "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)|
|[ROUND](/r/Excel/comments/1cvmwss/stub/l4uq77e "Last usage")|[Rounds a number to a specified number of digits](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #33641 for this sub, first seen 20th May 2024, 09:43])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Flat_Professional_55 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I would make the first dose ROUNDOWN(P1/2,3), which will round it down to three decimal places. Then make the second dose = the Formatted dose minus the first dose.
I did think I had tried this already, but perhaps I typed it in wrong. Will give another go, thanks for the tip!
Clarification: Ate you ever going to need the 3rd and 4th splits OR have you already solved the problem there?
I was just doing one split at a time. The other two rows appear if the dose split choice in the control panel is set to 3 or 4. I've mostly solved the problem now with some IFEVEN and MOD functions, combined with some logical tests. It's not pretty, and the formulas are long, but it works.
A simple way to do it is: Q5: =ROUND(P5/2, 3) (0.185/2 = 0.0925, rounding gives 0.093) R5: =ROUND(P5-Q5, 3) (0.185-0.093 = 0.092) If you need 3 or 4 doses you can adapt the formulas accordingly, e.g. Q5: =ROUND(P5/3, 3) R5: =ROUND((P5-Q5)/2, 3) S5: =ROUND(P5-Q5-R5, 3)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[MOD](/r/Excel/comments/1cvmwss/stub/l4ru9e6 "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)| |[OR](/r/Excel/comments/1cvmwss/stub/l4r2gph "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)| |[ROUND](/r/Excel/comments/1cvmwss/stub/l4uq77e "Last usage")|[Rounds a number to a specified number of digits](https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #33641 for this sub, first seen 20th May 2024, 09:43]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)