How do I create conditional excel formulas?
 

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.

How do I create conditional excel formulas?
 

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.

How do I create conditional excel formulas?
 

Thanks. This didn't quite work. Basically in my case this is for a ROI
calculator, where
A1= monthly rent cost
B1 = #of anticipated tests
C1 = # of prepaid tests
D1 = test fee for each test performed that exceeds # of prepaid tests

"Allllen" wrote:

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.

How do I create conditional excel formulas?
 

Hi Alllen, I think I figured it out with your help. Thanks.

"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.