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:

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: