Log In
Register
Home
December 16, 2021
Offline
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.
See Answer
Trusted Members
October 18, 2018
Offline
No file attached. Please try again.
December 16, 2021
Offline
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.
July 31, 2020
Offline
How about
=ROUNDUP(PRODUCT(I5:L5)/10,0)
Answers Post
1 Guest(s)
