varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
If column A contains buy then the value of the column d & e should be added esle part would be i.e if column a contain sell then the column d & e should be subtracted i am get to work for number i.e by using the formula after googling =IF(B2>5,C2+D2,C2-D2) i am looking for similar type or alternative / efficient way based on the text
here is the preview
here is the preview
Learn-IF-Condition.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Order Type | Qty | Price | Total | Tax | Grand Total | ||
2 | Buy | 10 | 25 | 250 | 5 | 275 | ||
3 | Buy | 5 | 25 | 125 | 5 | -100 | ||
4 | Buy | 5 | 25 | 125 | 5 | |||
5 | Sell | 10 | 25 | 250 | 5 | |||
6 | Sell | 10 | 25 | 250 | 5 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2:F3 | F2 | =IF(B2>5,C2+D2,C2-D2) |
D2:D6 | D2 | =(B2*C2) |