#1
|
|||
|
|||
#div/0!
Hi All I have a spreadsheet that calculates an average per week per item. Column A has a "From Date", Column B is the "To Date", Column C is the income and Column D has a formula to calculate the average per week. When there are no dates in a particular row, the above appears. I don't want to delete the formula as there will be data entered. Can I stop #DIV/0! from appearing and just show an empty cell? Many thanks. |
#2
|
|||
|
|||
=IFERROR(your formula, "")
|
#3
|
|||
|
|||
Thank you Xor for looking. I'm sorry, but I still can't get it work. This is the formula I am using: =G6/((F6-E6)/7
I typed in =IFERROR(G6/((F6-E6)/7,"")) What am I doing wrong? Many thanks |
#4
|
||||
|
||||
Try:
=IFERROR(G6/((F6-E6)/7),"") |
#5
|
|||
|
|||
Perfect! Thank you so much.
|
#6
|
||||
|
||||
The total number of opening parenthesis must equal the number of closing parentheis
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
||||
|
||||
Pecoflyer,
The number of parentheses are equal... they are just misplaced |
#8
|
|||
|
|||
Thank you all for your time.
|
#9
|
||||
|
||||
I'm getting too old for this...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#10
|
|||
|
|||
Pecoflyer
I guess you referred to the formula in the first line of #3. |
|