Excel Formula help

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am trying to create a formula in excel so that if I change a number in one cell it subtracts that amount from a different cell

for example

in A1 i have 9 and in B1 i have 15

when I change A1 to 10 B1 becomes 14.

Please help!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
In B1 type this formula
=24-A1