Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
=IF(C7=0,"",AVERAGE(H7:H11))
This formula is not working and I am not sure what I am doing wrong. I want the cell to remain blank and not show an error message when the related cells are blank. It is blank when the other cells are empty but it stays blank even when I enter values into the other cells. Probably a simple fix but I can't get it to work. All help is appreciated. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
What cell are you referring to when you say "I want the cell to remain
blank"? Is it a cell that is in your formula? If so, then you are getting a circular reference error. If not, then what's the specific error you're getting? Another thing to check is whether you have your workbook set to manual or automatic calculation. To check this, go to Tools, Options, Calculation, and select automatic calculation, and then close the dialogue box. Dave -- Brevity is the soul of wit. "japc90" wrote: =IF(C7=0,"",AVERAGE(H7:H11)) This formula is not working and I am not sure what I am doing wrong. I want the cell to remain blank and not show an error message when the related cells are blank. It is blank when the other cells are empty but it stays blank even when I enter values into the other cells. Probably a simple fix but I can't get it to work. All help is appreciated. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
japc90 wrote:
=IF(C7=0,"",AVERAGE(H7:H11)) This formula is not working and I am not sure what I am doing wrong. I want the cell to remain blank and not show an error message when the related cells are blank. It is blank when the other cells are empty but it stays blank even when I enter values into the other cells. Probably a simple fix but I can't get it to work. All help is appreciated. Thank you. Hi japc90, To see the AVERAGE(H7:H11) in the cell with your formula, you have to input a value in C7. If you want to see the blank if all the cells are blank and the result of AVERAGE(H7:H11) if C7<0 or the cells in the range H7:H11 have a value, you can use this formula: =IF(and(C7=0,iserror(AVERAGE(H7:H11))),"",AVERAGE( H7:H11)) -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
=if(c7=0,"",if(iserror(average(h7:h11)),"",average (h7:h11)))
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "japc90" escreveu: =IF(C7=0,"",AVERAGE(H7:H11)) This formula is not working and I am not sure what I am doing wrong. I want the cell to remain blank and not show an error message when the related cells are blank. It is blank when the other cells are empty but it stays blank even when I enter values into the other cells. Probably a simple fix but I can't get it to work. All help is appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |