varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
Need to print the value
- In column J if it is B then value of column F should be shown in column K
- In column J if it is S then value of column E should be shown in column K
Print Value.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | No | SYM | LTP | OPN | HGH | LW | PC | PDC | CHNG | B/S | VALUE | EXEPECTED OP | ||
2 | 1 | CSK | 30.35 | 30 | 32.35 | 30 | 30.8 | -0.45 | -1.46 | B | 30 | |||
3 | 2 | CTI | 187.25 | 190 | 190 | 185.7 | 191.6 | -4.35 | -2.27 | S | 190 | |||
4 | 3 | BBA | 46.1 | 46.7 | 47.05 | 45.75 | 47.3 | -1.2 | -2.54 | 0 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J2:J4 | J2 | =IF(D2=F2,"B",IF(D2=E2,"S",)) |