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.
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
Bookmarks