My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

calculation question|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / calculation question|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
calculation question
Avatar
py clen
Member
Members
Level 0
Forum Posts: 11
Member Since:
December 16, 2021
sp_UserOfflineSmall Offline
1
January 15, 2022 - 1:48 am
sp_Permalink sp_Print

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.

sp_AnswersTopicSeeAnswer See Answer
Avatar
Alan Sidman
Steamboat Springs, CO
Member
Members


Trusted Members
Level 0
Forum Posts: 174
Member Since:
October 18, 2018
sp_UserOfflineSmall Offline
2
January 15, 2022 - 10:14 am
sp_Permalink sp_Print

No file attached.  Please try again.

Avatar
py clen
Member
Members
Level 0
Forum Posts: 11
Member Since:
December 16, 2021
sp_UserOfflineSmall Offline
3
January 15, 2022 - 11:12 pm
sp_Permalink sp_Print sp_EditHistory

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.

Avatar
Fluff
Member
Members
Level 0
Forum Posts: 34
Member Since:
July 31, 2020
sp_UserOnlineSmall Online
4
January 16, 2022 - 12:36 am
sp_Permalink sp_Print

How about

=ROUNDUP(PRODUCT(I5:L5)/10,0)

sp_AnswersTopicAnswer
Answers Post
Avatar
py clen
Member
Members
Level 0
Forum Posts: 11
Member Since:
December 16, 2021
sp_UserOfflineSmall Offline
5
January 16, 2022 - 9:49 pm
sp_Permalink sp_Print

Great, that works like a charm

Avatar
Fluff
Member
Members
Level 0
Forum Posts: 34
Member Since:
July 31, 2020
sp_UserOnlineSmall Online
6
January 17, 2022 - 12:27 am
sp_Permalink sp_Print

Glad to help & thanks for the feedback.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Fluff, Ineke Smit
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 186
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6546
Posts: 28658

 

Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen