PDA

View Full Version : help needed with formula



stevemunckton
2012-01-21, 11:56 AM
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
2012-01-21, 12:13 PM
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