MS Excel + Function + Variable Help

Discussion in 'Programming' started by papa_face, May 1, 2008.

0
  1. #1
    Hello,

    Sorry if this is in the wrong place, I wasn't sure where else to put it.

    Please can someone help me.
    I am trying to make a formula dynamic, this is a very simple example of what I am trying to do:
    I am trying to append a number that is stored in a field to a function
    Cell B4 contains the number 5

    My function:
    =SUM(F*,U*)
    Code (markup):
    Where the * are I want it to substitute it with a 5. So literally speaking:
    =SUM(F[B](B4)[/B],U[B](B4)[/B])
    Code (markup):
    Any ideas?
    I would appreciate your help :)
     
    papa_face, May 1, 2008 IP