=IF(COUNT(AVERAGE(Marks!T15:V15))=0,"",AVERAGE(Marks!T15:V15))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Khalil Handal" <(E-Mail Removed)> wrote in message
news:%23M$(E-Mail Removed)...
> My formula is:
> =IF(COUNT(AVERAGE(Marks!T15:V15))="","",AVERAGE(Marks!T15:V15))
> The range T15:V15 has either numeric values or average from other cell in
> the sheet.
>
> Khalil
>
> "JE McGimpsey" <(E-Mail Removed)> wrote in message
> news:jemcgimpsey-(E-Mail Removed)...
>> If your formula is
>>
>> =A1/B1
>>
>> then use
>>
>> =IF(B1=0,"",A1/B1)
>>
>> In article <#(E-Mail Removed)>,
>> "Khalil Handal" <(E-Mail Removed)> wrote:
>>
>>> Is there a VBA code to check all the sheets in a workbook so as to give
>>> an
>>> empty cell (nothing seen in the cell) instead of the error values like
>>> #DVD/0 (division over zero).
>>>
>>> Khalil
>
>
|
