Blank instead of #DIV/0!

[G1032]

Hi folks
In screenshot below I have 3 columns pulling data from another worksheet.
Data refreshes every day and adds a new row to the top of the sheet.
I have the formula in Col A as seen, IF(ISNUMBER..........), copied to a few thousand rows, which allows blank spaces if no date there.

The columns B and C are calculating rolling averages as per formula shown in screenshot below.

How do I write an IF statement to include the =AVERAGE(OFFSET........) formula so that a black space can be returned instead of #DIV/0!
I need blank spaces so I can graph the data

Thanks

 

[G1032]

Edit - It actually seems to graph OK with the #DIV/0! in there. But the question still remains, if only for curiosity sake alone.

 

[footoo]

How to correct a #DIV/0! error - Microsoft Support

Use IF or IFERROR to correct a #DIV/0! error in Excel

support.microsoft.com

 

[G1032]

How to correct a #DIV/0! error - Microsoft Support

Use IF or IFERROR to correct a #DIV/0! error in Excel

support.microsoft.com

Well that was easy. Thanks for that

 

[G1032]

Hi folks
Another issue with this sheet that I can't figure out how to fix.
Sheet refreshed daily. New row created at top of Sheet1 each day.
Sheet2 used to calculate rolling averages, standard deviation etc. etc across the different columns
However, depiste having the formulas copied all the way down 5000 rows, when the bottom rows get shifted down upon daily refresh, the formulas also shift down and leaves blank cells on the bottom row of data.
How do I get the formulas to copy down when the bottom row shifts down after daily refresh?

I can do a macro do copy formulas down but would prefer to have it done automatically

 

[footoo]

Hi folks
Another issue with this sheet that I can't figure out how to fix.
Sheet refreshed daily. New row created at top of Sheet1 each day.
Sheet2 used to calculate rolling averages, standard deviation etc. etc across the different columns
However, depiste having the formulas copied all the way down 5000 rows, when the bottom rows get shifted down upon daily refresh, the formulas also shift down and leaves blank cells on the bottom row of data.
How do I get the formulas to copy down when the bottom row shifts down after daily refresh?

I can do a macro do copy formulas down but would prefer to have it done automatically

Moved to here : Auto add formulas to new rows

 

[footoo]

.