Results 1 to 2 of 2

Thread: help needed with formula

  1. #1

    help needed with formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    98
    Articles
    0
    Excel Version
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •