HELP!!!!!
 

You have two options. You could try using the OR statement in your existing
formula:

=IF(F7=27000,(19200/$G$4),IF(F7=26500,(F7-100)*($G$4)/($G$4),IF(F7=25000,(F7-200)*($G$4)/($G$4),IF(OR(F6=6500,F6=6000,F6=5500,F6=5000),(241 00)-(P3+P4)/($G$4)*($G$4),IF(F7=17000,(12000/$G$4),(F7-200)*($G$4)/($G$4))))))

Or you could set up a user defined function in a VBA module along the lines
of:

Function MyFunction(testVal1 As Range, testVal2 As Range, _
Const1 As Range, Const2 As Range, const3 As Range)

If testVal1 = 27000 Then
MyFunction = 19200 / Const1

ElseIf testVal1 = 26500 Then
MyFunction = (testVal1 - 100) * (Const1 / Const1)

ElseIf testVal1 = 25000 Then
MyFunction = (testVal1 - 200) * (Const1 / Const1)

ElseIf testVal2 = 6500 Then
MyFunction = 24100 - (Const2 + const3) / Const1 * Const1

ElseIf testVal2 = 6000 Then
MyFunction = 24100 - (Const2 + const3) / Const1 * Const1

ElseIf testVal2 = 5500 Then
MyFunction = 24100 - (Const2 + const3) / Const1 * Const1

ElseIf testVal2 = 5000 Then
MyFunction = 24100 - (Const2 + const3) / Const1 * Const1

ElseIf testVal1 = 17000 Then
MyFunction = 12000 / Const1

Else
MyFunction = (testVal1 - 200) * (Const1 / Const1)
End If

End Function

In your worksheet you could then enter =myfunction(F7,F6,G4,P3,P4) to get
the same result.

Regards
Rowan

"Dougieg" wrote:

Hi there...

Is there any way to make the following formula shorter??? This is
ridiculous, and I need the formula to evaluate such as it does... Sorry for
the crosspost, but I am desperate!!!!


=IF(F7=27000,(19200/$G$4),IF(F7=26500,(F7-100)*($G$4)/($G$4),IF(F7=25000,(F7-200)*($G$4)/($G$4),IF(F6=6500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=6000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F7=17000,(12000/$G$4),(F7-200)*($G$4)/($G$4)))))))))


Thank you

Doug