What am I doing wrong? I want column C to show "No" if the value in column B is greater than 20 (highlighted cells).
This board has been so helpful for an Excel beginner like me, thank you!
This board has been so helpful for an Excel beginner like me, thank you!
excel help.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Requested Amount | Activity | Include? | ||
2 | #VALUE! | #VALUE! | |||
14 | 1 via-11.0 mCi/via | 11.0 | Yes | ||
15 | 1 via-11.0 mCi/via | 11.0 | Yes | ||
16 | 1 via-11.0 mCi/via | 11.0 | Yes | ||
17 | 1 via-11.0 mCi/via | 11.0 | Yes | ||
18 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
19 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
20 | 1 via-187.0 mCi/via | 187.0 | Yes | ||
21 | 1 via-10.8 mCi/via | 10.8 | Yes | ||
22 | 1 via-16.0 mCi/via | 16.0 | Yes | ||
23 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
24 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
25 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
26 | 1 via-100.1 mCi/via | 100.1 | Yes | ||
27 | 1 via-12.0 mCi/via | 12.0 | Yes | ||
28 | 1 via-12.48 mCi/via | 12.48 | Yes | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2,B14:B28 | B2 | =(RIGHT(LEFT(A2,LEN(A2)-7),LEN(LEFT(A2,LEN(A2)-7))-6)) |
C2,C14:C28 | C2 | =IF(B2>"20","No","Yes") |