Thread: If formula ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default 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