A UNIQUE FORMULA

[FLATRATE]

EXAMPLE: I want to multiply one cell with a dollar amount in it, by a cell
that has a quantity of employees in it. I want the dollar amount to remain
the same for the first two employees and only increase after the 3rd employee
is entered. If the amount is $4000, I want it to remain at $4000 until the
3rd employee is entered making it $8000 and then each additional employee
would add $4000. 10 employees would be $36,000. Can it be done? Appreciate
any help.

 

[Dave]

Hi,
If your $4000 is in B2, and number of employees in A2:
=IF(A2>2,(A1-2)*B2,B2)
Change the ref's to suit your data.
Fegards - Dave.

 

[Dave]

Oops:
Should be:
=IF(A2>2,(A1-1)*B2,B2)

 

[Jacob Skaria]

Use the IF condition. Suppose

A1 = Emp Count
B1 = $ 4000

= IF(A1>2,(A1-1)*B1,B1)

If this post helps click Yes

 

[FLATRATE]

Thanks Dave! It worked.

Oops:
Should be:
=IF(A2>2,(A1-1)*B2,B2)

 

[FLATRATE]

Thanks! It works.

Use the IF condition. Suppose

A1 = Emp Count
B1 = $ 4000

= IF(A1>2,(A1-1)*B1,B1)

If this post helps click Yes