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.