View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

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