Forum Discussion
How can i get a sum from different if conditions
Hello,
First time poster and excel rookie.
I wanna make a sheet where i can input a value (in this case a measurement) then i want the sheet to check whether the input is between a given range and the output the value plus another value. The problem is, this is for a ISO standard scheme, so i want the output value it adds to the number to change whether the input is between different ranges (E.G 0.5-3, 3-6, 6-12) and then add the correct number value to the input.
Sorry if my explanation was a little confusing Im new to this so i might not be using the right terminology 😅
Thanks in advance, Benjamin
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
If I understood you correctly, I think you need the XLOOKUP function
In this example, input in B1, test against E2:E4, then add conditional increment in G2:G4, result in B2.
