Thread: Error #DIV/0!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default Error #DIV/0!

thank you so much.

"Eduardo" wrote:

Hi,
Try
=if(PMTSN="","",AVERAGEIF(PMTSN,F260,PMTEXR))
If this was helpful please say yes, thanks

"Tufail" wrote:

i am using following formula but when my PMTSN range doesn't have any value
then #DIV/0! error is coming out.

=AVERAGEIF(PMTSN,F260,PMTEXR)

thanks in advance.