How do I create conditional excel formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Messy Formula needs clean up help! 7
Finding the weighted average of text that have been given values 1
VLOOKUP, a table with text and numerics 7
How to create one additional warning flag into my logic? 1
Nested IF statements using AND / OR 2
How do I get the IF function to work on more than one criterion? 5
Formula help in a circular reference 2
Creating a Formula in Excel 4

Back
Top