Column J row 6 is a drop-down box of options including: 0,1,2,3+
Column K row 6 is an If/Then as follows: =IF(J6="0",0,IF(J6="1",0.05,IF(J6="2",0.1,IF(J6="3+",0.15,))))
Problem: K returns a zero for 0,1,2 and a .15 for a 3. So only the 3 is computing correctly but the others are not. If/Then appears to be written correctly. Any ideas on the problem?? Thanks!
Bookmarks