Hello All,

I've made a grid in which I can enter a pts weight and calculate a medication dose to administer. However, I need the formula to contain a maximum dosage, and I'd like for a message to pop up when the sum is greater than the maximum dose to be given.

Here's an example:

0.5mg x 20kg = 10mg, so my formula looks like this: =0.5*I1

However, my max dose is 20mg. How do I put in the part to max the dose at 20mg with a pop-up warning message?

Thank you
Amber