help needed with formula

stevemunckton

New member
Joined
Jan 21, 2012
Messages
1
Reaction score
0
Points
0
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

New member
Joined
Oct 3, 2011
Messages
99
Reaction score
0
Points
0
Location
Italy
Excel Version(s)
Excel 2010
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
 
Top