Thread: Nested If returns error (too many arguments)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
plally plally is offline
external usenet poster
  
Posts: 6
Default Nested If returns error (too many arguments)
Here is my If statement. I am getting an error message "too many arguments".
Can you tell me what I'm missing?

=if(or(R4V3,S4<V3,),(if(and(R4=V3,S4V3),(yearfra c(V2-B4)*U4),if(R4=S4,T4*U4),if(and(R4<V3,S4=V3),(((C4-V1)/365)*U4),0))

Thanks in advance,
Reply With QuoteReply With Quote