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.

=IFERROR(your formula, "")

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

Try:

=IFERROR(G6/((F6-E6)/7),"")

Perfect! Thank you so much.

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

Pecoflyer,

The number of parentheses are equal... they are just misplaced

Thank you all for your time.

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

Pecoflyer

I guess you referred to the formula in the first line of #3.