| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If function with average fomula to be tru or false
One way:
=IF(COUNTIF(A1:J1,0)=10,AVERAGE(A2:J2),5) In article , Linda wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My IF function is saying something is false when it is true... | Excel Worksheet Functions | |||
| VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 | Excel Programming | |||
| Set Function to False -Why?? | Excel Programming | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| IF Function returns False instead of 0 | Excel Worksheet Functions | |||
Linear Mode
