Thread: If function with average fomula to be tru or false
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LINDA LINDA is offline
external usenet poster
  
Posts: 205
Default If function with average fomula to be tru or false
I need help for the following situation:
If A1:J1=0, Average A2:J2(true), 5(false)

I typed in the fomula: IF(A1:J1=0,AVERAGE(A2:J2),5)

But it did not work. I kept gettng #signs. Deeply appreciated if somebody
help.

Thanks,
Linda
Reply With QuoteReply With Quote