varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
Excel Sum & Sub Based On The Condition
At the moment i am able to sum by using this in D2
and sub by using this in D4
- Need to sum in Column D if the value is Yes in Column B and the value should be taken from g1
- Need to sub in Column D if the value is No in Column B and the value should be taken from g1
- No changes in Column D6 as this dosn't have any condition like Yes or No
At the moment i am able to sum by using this in D2
Code:
=ROUND(MIN((C2*100),1000),2)+G1
Code:
=ROUND(MIN((C2*100),1000),2)-G1
Text Based Sum.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Name | Increment | DA | Current Pay | Expected Result | Increment Amount | 5 | ||
2 | Ram | Yes | 5 | 500 | 505 | ||||
3 | Prasad | Yes | 5 | 500 | 505 | ||||
4 | Arjuan | No | 5 | 500 | 495 | ||||
5 | Rajesh | No | 5 | 500 | 495 | ||||
6 | Dinesh | 5 | 500 | 500 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D6 | D2 | =ROUND(MIN((C2*100),1000),2) |