If function with average fomula to be tru or false

L

Linda

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an IF Formula 1
Create Detail Sheets from Pivot Table 1
Problem with SET & REF function 0
If function and math formulas 3
Average last seven if not zero 5
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
If Formula (visible cells only) 0
averaging non-contiguous data using arrays 1

Top