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

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.