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
 Date formula in excel dd/mm/yyyy  Guide
 Tmobile check balance  Guide
 Number to words in excel formula  Guide
 How to calculate 90 days from date in excel  Guide
 Excel grade formula  Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 8, 2021 at 11:25 AM
Nov 8, 2021 at 11:25 AM
Hi Turner,
Something like this?:
=IF(A2=99,A4A3,"")
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,A4A3,"")
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