I need to calculate a number (of setups for analytical testing) based upon how many samples I have
at the moment I am using an IFS statement that looks at the product of 4 cells (f4:I4) and adjusts the number of setups based on the result
I want to increase the number of setups for every ten (10) samples, as shown in the example that I attached.
If someone knows how to make this a more efficient statement as I currently have I would appreciate it.
No file attached. Please try again.
now with file uploaded
I need to calculate a number (of setups for analytical testing) based upon how many samples I have
at the moment I am using an IFS statement that looks at the product of 4 cells (f4:I4) and adjusts the number of setups based on the result
I want to increase the number of setups (row highlightedin yellow) for every ten (10) samples, as shown in the example that I attached.
If someone knows how to make this a more efficient statement as I currently have I would appreciate it.
How about
=ROUNDUP(PRODUCT(I5:L5)/10,0)
Great, that works like a charm
Glad to help & thanks for the feedback.
