Excel assistance; IF formula to calculate remaining balance
Closed
Turner
-
Updated on Nov 8, 2021 at 12:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 8, 2021 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 8, 2021 at 11:25 AM
Related:
- Excel formula to calculate remaining balance
- Excel date format dd.mm.yyyy - Guide
- Tmobile check balance - Guide
- How to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
Nov 8, 2021 at 11:25 AM
Nov 8, 2021 at 11:25 AM
Hi Turner,
Something like this?:
=IF(A2=99,A4-A3,"")
Meaning if cell A2 contains 99 (a certain value), then subtract cell A3 from A4 (calculate a remaining balance) otherwise show nothing.
If this is not what you are after, then provide more details.
Best regards,
Trowa
Something like this?:
=IF(A2=99,A4-A3,"")
Meaning if cell A2 contains 99 (a certain value), then subtract cell A3 from A4 (calculate a remaining balance) otherwise show nothing.
If this is not what you are after, then provide more details.
Best regards,
Trowa