If formula ?

L

Lime

Is ther a better way I keep getting error to many Arguments

=if(Y8=7,(AR23+20),(AR23),if(J20+20>=J17,(E23+H26+10)))

Thanks,
Lime
 
B

Barb Reinhardt

You have too many arguments for your IF function

=if(Y8=7, (AR23+20), (AR23), if(J20+20>=J17,(E23+H26+10)))
value if true value if false this is not
necessary for your IF
 
J

joeu2004

Lime said:
Is ther a better way I keep getting error to many Arguments
=if(Y8=7,(AR23+20),(AR23),if(J20+20>=J17,(E23+H26+10)))
Click to expand...

Not a question of "better". You simply have the wrong
format. To help you, it would be useful if you could
express your intended logic in English. For example
(wild guess):

if Y8=7, then AR23+20
else if J20+20 >= J17, then E23+H26+10
else AR23

That can be expressed as:

=IF(Y8=7, AR23+20, IF(J20+20 >= J17, E23+H26+10, AR23))
 
L

Lime

Here is what I'm trying to do.
if Y8=7 then AR23+20 if not than show what's in AR23
else if J20+20 >= J17, then E23+H26+10

Thanks,
Lime
 
L

Lime

Here is what I'm trying to do.
if Y8=7 then AR23+20 if not than show what's in AR23
but if J20+20 >= J17, then E23+H26+10
 
J

joeu2004

Lime said:
Here is what I'm trying to do.
if Y8=7 then AR23+20 if not than show what's in AR23
else if J20+20 >= J17, then E23+H26+10
Click to expand...

That does not even make sense in English. The first
statement (if ... then ...; if not, then ...) precludes the
else-if. (Hint: What should the result be if J20+20 < 17?)

I tried to fix that by suggesting that perhaps you want
AR23 only if Y8<>7 __and__ J20+20 < J17. But either
you did not understand my fix (which is correct for that
purpose), or my guess is incorrect.
 
Top