A1 = fee
B1 = # of tests
C1 = # of allowed tests

this formula in D1
=IF(12 * A1 + B1 - C1 0,(12 * A1 + B1 - C1) * A1 * 12, 0)

(assuming you want to give 0 if it is <=0)

but this is a very strange formula. It doesn't really make sense to me, so
perhaps you can explain it again. Or you can try to understand it, and adapt
it so it works.

The basic formula is =IF(test , value if test is true , value if test is
false)
--
Allllen


"Todd53" wrote:

I have this formula I can't seem to work:

(fee x 12) + (#of Tests - #of allowed tests), and if a positive number
then*per test fee, *12 months.