Hello,
We use a Google Sheet for a non-profit spay and neuter clinic. We give 4 different meds based on the animal's weight. Weight x dosage factor/pound = dosage.
Quantities are always positive. Syringes below 1cc can calculate to 2 decimal places (i.e. 0.77). Syringes above 1cc only use 1 decimal place (i.e. 1.8).
Is there a way to do a conditional format or custom # format to change the # of decimal places based whether the calculation is below or over 1.
Or do I need to create an app script? If so, could you point me to a site that could help me get started?
Thanks, Andy