• Resolved marie26

    (@marie26)


    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!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘conditional equation help’ is closed to new replies.