conditional equation help
-
Hello, I am using a simple equation that returns the results I want but I would like to add a condition. The formula is for figuring out a weight-based single dose.The result is given in mL
Here is the formula:
PREC(fieldname2*1.5, 2)
Fieldname2 is user-entered weight, and dosage is weight X 1.5, result is mL with 2 decimals
I getthe correct results so this part of the formula works for me.
I would like to cap the dosage at 5mL maximum regardless of weight.Any suggestions welcome, sorry I cannot link to url as this is still in development/testing. I tried on my own but my results come off wrong so clearly I am missing a step.
Thanks!
The topic ‘conditional equation help’ is closed to new replies.