Thread
:
Trouble with a conditional statement
View Single Post
#
2
Ron Coderre
Posts: n/a
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
Reply With Quote