Excel assistance; IF formula to calculate remaining balance

Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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