View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Metcalf Jeff Metcalf is offline
external usenet poster
 
Posts: 9
Default If..else..then statement

I'm trying to write this compare statement, but I keep getting errors about
to many arguements:

In Cell C20
IF C10=0, then C15
ElseIF C15=0, then C10
ElseIF C15=0 and C10=0
then
Average(C10,C15)
Else 0

Thanks in advance