locked
Results into different cells RRS feed

  • Question

  • My problem: I use a variable that causes output values to change and the changed values have to go in to different cells. For example the various variable numbers could be 25, 30, 40 and are in cells A1 to A3. When the variable is 30 is used I need the result in B2 without changing the result of the 25 variable that put a result in B1.

     

    The following is an example where the variable 30 was selected and it created the correct value 355,648 and put it in the right cell but replaced the value in the cell below 25 with a 1 whereas before there was the correct value for the 25 variable. If I could get the result of the 25 variable to not be replaced every thing would be fine.

     

    =IF(N86='C:\Documents and Settings\EXCEL\TCE\VSF 08\[VariablesR.xls]Loan1'!$E$25,$R73,1)

     

    25

    30

    35

    40

    50

    60

    1

    355,648

    1

    1

    1

    1

     Thanks

    Wednesday, February 6, 2008 2:32 PM