dear mr gebobs

thanks for your reply.

i got the clue from your mail i.e. iif function relates to access
and not to excel.

from the clue, i could solve my problem.

m s narayanan