Ok, I am self-teaching so bear with me if this is simple or even impossible or if i am confusing/overthinking things.
I have a table within a spreadsheet on Excel. An example of what I want to be able to do is;
In cell K23 i want the following to automatically calculate;
If the value in cell J22 is greater than cell b37 but less than cell b38 then I need to perform c38*j22-d38, or ifJ22 is greater than cell b38 but less than cell b39 I need to perform c39*j22-d39 or if j22 is greater than b39 but less than b40 I need to perform c40*j22-d40 and so on until row 45.
Is this possible? Have I made sense. I'm so sorry if not.
Thank you!
I have a table within a spreadsheet on Excel. An example of what I want to be able to do is;
In cell K23 i want the following to automatically calculate;
If the value in cell J22 is greater than cell b37 but less than cell b38 then I need to perform c38*j22-d38, or ifJ22 is greater than cell b38 but less than cell b39 I need to perform c39*j22-d39 or if j22 is greater than b39 but less than b40 I need to perform c40*j22-d40 and so on until row 45.
Is this possible? Have I made sense. I'm so sorry if not.
Thank you!