Hello again... I am writing an if then formula for use in my research database. The goal with this formula is to assess whether or not a dosage is correct for a calculated value.

If CrCl is > 30, dosages of 40, 2.5, and 5000 (which represent dosages of various drugs) are appropriate.
If CrCl is < 30, dosages of 30 and 5000 are appropriate. Dosages of 40 or 2.5 are not appropriate.

If dosage is appropriate, print "Y", else print "N"

So, in short, I have a critical value (30). Above this value there is a Y or N question. Below this value, there is a different Y or N question. Whichever question is asked, I want it to print a Y or N (above or below the value is irrelevant, only the accuracy of the Y or N question).

I am using a COUNTIF statement to tally the number of "Y"s.

What do you ladies and gents think?