If formula

[ad335i]

Looking to setup an If formula with multiaple variables

selling apples
for the first apple sold the agent will earn $5
for the second apple sold the agent will earn $10
for the 3rd apple sold the agent will earn $15
and any apple above and including the 4th will earn $ 20 each

so if the agent sold 5 apples they will be paid $70

 

[cjcobra]

Number of Apples in Cell A1

=IF(A1=1,5,IF(A1=2,15,IF(A1=3,30,IF(A1>=4,((A1-3)*20+30),0))))

 

[3link]

Never mind. Cjcobra got it.

 

[Yahya]

and try this UDF

Function MultIt(c As Integer) As Integer
Dim arrC(), i As Long
ReDim arrC(1 To c)

For i = LBound(arrC) To UBound(arrC)
    Select Case i
        Case 1
            arrC(i) = 5
        Case 2
            arrC(i) = 10
        Case 3
            arrC(i) = 15
        Case Else
            arrC(i) = 20
    End Select
Next i
    MultIt = Application.WorksheetFunction.Sum(arrC)

End Function

 

[Armando Montes]

Another one:
=(A2*5)+(MAX(A2-1,0)*5)+(MAX(A2-2,0)*5)+(MAX(A2-3,0)*5)

 

[AMAS]

Maybe something like this:

=CHOOSE(A1,5,10,15,20,70)

AMAS