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 December 27, 2022 - Nov 8, 2021 at 11:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 8, 2021 at 11:25 AM
Related:
- Excel formula to calculate remaining balance
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Formula to calculate vat in excel - Guide
- Tmobile check balance - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
