Excel - formulas

  • Thread starter Thread starter Karly Hurst
  • Start date Start date
K

Karly Hurst

I have been trying to come up with a formula for the last
two days and its driving me crazy.
I have three cells.
1)adds up the total of days a product has been used
2)the rate of which we will charge for.
3) the total of days used, multiplyed by the rate.

The problem is if the no of days is more 7 i want the
total to be the same as if they have used the product for
6 days.

What formula can I use to get this..

please help!!
 
Karly Hurst said:
I have been trying to come up with a formula for the last
two days and its driving me crazy.
I have three cells.
1)adds up the total of days a product has been used
2)the rate of which we will charge for.
3) the total of days used, multiplyed by the rate.

The problem is if the no of days is more 7 i want the
total to be the same as if they have used the product for
6 days.
Click to expand...

Suppose your three cells were A1, A2 and A3. The formula in A3 could be
=IF(A1>7,6*A2,A1*A2)

If the number of days is equal to 7, this gives a larger result than if
greater than 7. Is this what you meant, or should it have been >=7 (i.e.
6)? If so, you could use either
Click to expand...
=IF(A1>6,6*A2,A1*A2)
or
=MIN(6,A1)*A2
 
Back
Top