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