+ Reply to Thread
Results 1 to 4 of 4

Multiple functions in one cell? An alternate techinque perhaps?

  1. #1
    Registered User
    Join Date
    04-25-2007
    Posts
    3

    Multiple functions in one cell? An alternate techinque perhaps?

    The forumula that goes into cell F4 -

    =(J3-C16)/(0.05*C16)

    As you can see it takes data from cells J3 and and C16. The data in C16 is static and cannot be changed by the user but the data in J3 needs to be changed according to the users preference in order to get the desired result.

    Now the problem is that there are multiple cells in row 'J' that the user can enter data into, which one to enter data into depends on the user according to what he has available - he may fill in 1 or more but there will not be any conflicts in F4 as the final value in F4 will be the same for the particular range the user is using at the time. (There can be different ranges depending on the situation but the value in F4 will remain constant for that situation). According to the formula ive used above it only processes data from cell J3, if the user didnt have that but had the data for say cell J5 how would I be able to get F4 to utilise that data (without having to change the formula in the spreadsheet ofc).

    Im not really pro when it comes to excel so bear with me, its also the first time im using these forums so I'm not sure if i've included all the neccesary data.

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    What is the specific range in column J that the user can change that you would like to update this formula? Also, will there be more than one item entered in column J? I.e. could there potentially be values in both cells J3 and J5?

  3. #3
    Registered User
    Join Date
    04-25-2007
    Posts
    3
    I guess range isnt the best term to use, but provided the user enters the correct data - this data is obtained from elsewhere in a particular format - the value in F4 will be the same. And yes the user might enter values into J3 and J5 at the same time but there will be no need to, as either should be sufficient inorder to get the output in F4, which will be the same according to the data he has obtained. In other words, if he enters data into one cell in J the other cells can be blocked out to prevent any errors from occuring but theres no way to tell which cell the user has data for. Again the output in F4 will be the same depending on the "range" the user has for the situation so data in any column in J will yield the same result due to the formula (because the static data in row C is different, but thats a different matter).

    Sorry if my explanation is a little out of hand.

  4. #4
    Registered User
    Join Date
    04-25-2007
    Posts
    3

    Cool

    Problem solved! I used nested IFs in F4 to go through J starting from the top. If the value was at default it skips to the next one in the row until/if a modified value is detected.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1