- Joined
- Aug 6, 2017
- Messages
- 1
- Reaction score
- 0
Please help me sort out this problem as I need to use it everyday and it is really a headache if it goes wrong,
I have a target to sell 1500 units (A1) which is calculated on a daily achievement, suppose I achieved 50 units (A4) today and my till date achievement is 500 units (A2), the balance is 1000 units (A3), but what I achieved today should be added to (A2) and deducted from (A3) just by entering a new number in (A4) which is displayed till midnight only, after that this cell (A4) must be blank.
Every effort will be a helpful
I have a target to sell 1500 units (A1) which is calculated on a daily achievement, suppose I achieved 50 units (A4) today and my till date achievement is 500 units (A2), the balance is 1000 units (A3), but what I achieved today should be added to (A2) and deducted from (A3) just by entering a new number in (A4) which is displayed till midnight only, after that this cell (A4) must be blank.
Every effort will be a helpful