Excel assistance; IF formula to calculate remaining balance

Turner - Updated on Nov 8, 2021 at 12:04 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Nov 8, 2021 at 11:25 AM
Hello,

How do I write a formula in excel that says if any cell contains a certain value, then calculate a remaining balance?

System Configuration: Windows / Chrome 95.0.4638.54

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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
0