Nope. IIF is an Access function. IF is the Excel Function. Other than that:

* the parentheses around b2="XYZ" are superfluous
* there is no ELSE option in the formula
* the ," at the end will cause an error


* the whole thing looks like a kludge

No idea what you are trying to accomplish.

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