Thanks Ron.

That fixed the problem. I knew it had to be something simple, but I sure
couldn't find the answer in the Help section.

Jim

"Ron Coderre" wrote:

The X in your formula need to be "X":
=IF(F7="X",J23*0.02,J23)

In quotes, Excel treats it as the letter X. Without quotes, Excel is
looking for a range named X.

Regards,
Ron