Excel Formula help

Closed
kroc - Sep 30, 2010 at 01:31 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 1, 2010 at 05:23 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 1, 2010 at 05:23 AM
In B1 type this formula
=24-A1
0