help needed with formula

[stevemunckton]

Hi
i am having a problem trying to get Excel to formulate. I need for instance lets say i have a number of 2000 in one cell and i need to subtract 50, 350, and 600. however i need the sheet to show what is in the table:

			2000
50		50	1950
350		350	1600
600		600	1000

in the left column are the standard fixed values. i need excel when i input the 2000 it must automatically show the values in red. thus the amount and the remainder. :confused2:

 

[Canapone]

Hi, a first attempt.

In D1: 2000

in D2 to be copied down

=if(d$1<>0,d$1-sum(c$1:c1),"")

in c2 and below

=if(d$1<>0,a2,"")


a2 in the example is 50, a3 350 (...)

Hope it helps