Solved: want to remove #div/0 error by vbnull string

[ravinder_tig]

Hi Guys

I'm quite new to excel programming and i do need your help regarding one of my projects i'm summarizing few sheets to a master worksheet

criteria is bascially month and week based

when i apply average forumla for a month i did get the avg for a month

but when a record for tht month is unfilled

eg weekend is off so no values for that date that displays div/0 error

I want a Macro which cud change this div/0 error in a selected range to be null
so it didn't reflect in avg function on final sheet and gives that value there


I'm attaching a file with this thread


plz don't mind my language
i'm quite new to technical terms


your help would be gr8ly appriciated


Thanks and Regards,

Ravinder S

[Bob Phillips]

Use formulae such as

=IF(F6="","",G6/F6)