Forum Discussion
Solved
Numbers in drop down list invisible
Dear reader(s), I am working on a scoring sheet and I need someone's help! Example: A1 has the following drop down options: Arm, Head, Hand, Foot. In B1 I have the code: =IF(A1="hea...
Use
=IF(A1="Select",0,IF(A1=1,1,IF(A1=2,2,IF(A1=3,3,""))))
or
=IF(A1="Select", 0, IF(A1="", "", A1))
Use
=IF(A1="Select",0,IF(A1=1,1,IF(A1=2,2,IF(A1=3,3,""))))
or
=IF(A1="Select", 0, IF(A1="", "", A1))
- =IF(A1="Select",0,IF(A1=1,1,IF(A1=2,2,IF(A1=3,3,""))))
Worked PERFECTLY!
Can't believe the answer was so simple.
Dankje, Hans!!!
