If formula ?
 

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

If formula ?
 

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

"Lime" wrote:

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

If formula ?
 

"Lime" wrote:
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)))

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))

If formula ?
 

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

" wrote:

"Lime" wrote:
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)))

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))

If formula ?
 

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



"Lime" wrote:

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

" wrote:

"Lime" wrote:
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)))

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))

If formula ?
 

"Lime" wrote:
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

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.