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!

    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:
    50 50 1950
    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
    Excel Version
    Excel 2010
    Hi, a first attempt.

    In D1: 2000

    in D2 to be copied down


    in c2 and below


    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