+ Reply to Thread
Results 1 to 7 of 7

In spec/out of spec formula

  1. 04-13-2024, 11:41 PM #1
    Sam Burton
    Sam Burton is offline
    Registered User
    Join Date
    04-13-2024
    Location
    Lincoln
    MS-Off Ver
    MS Office 365
    Posts
    7

    In spec/out of spec formula

    Hi guys,

    So I'm trying to make my spreadsheet a bit more automated.

    As you can see from the sheet attached I am entering figures in the 1-10 column's that coincide with the size column's to see if it's in spec or not. The size column's have entered the spec size's and I'm wanting the numbers 1-10 to highlight when they aren't in spec, this needs to be above and below, and I'm also wanting the column's to automate a percentage what's in spec/out of spec.

    Appreciate any help.

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-14-2024, 12:12 AM #2
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,443

    Re: In spec/out of spec formula

    Please change Cell L5 to 12.5 - 17.5
    Please select this area range at this time B3:K5
    Conditional formatting formula as below , please select yellow color
    Attached Files Attached Files
    Last edited by wk9128; 04-14-2024 at 10:13 PM.
    Reply With QuoteRegister To Reply
  3. 04-14-2024, 02:06 PM #3
    Sam Burton
    Sam Burton is offline
    Registered User
    Join Date
    04-13-2024
    Location
    Lincoln
    MS-Off Ver
    MS Office 365
    Posts
    7

    Re: In spec/out of spec formula

    Hi, thank you that works perfectly!

    What about calculating the percentage of out of spec/in spec ranges?

    Thanks
    Reply With QuoteRegister To Reply
  4. 04-14-2024, 10:16 PM #4
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,443

    Re: In spec/out of spec formula

    All completed, I have fully utilized it for you, as attached in POST # 02
    Last edited by wk9128; 04-16-2024 at 05:11 AM.
    Reply With QuoteRegister To Reply
  5. 04-14-2024, 11:12 PM #5
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: In spec/out of spec formula

    CF formula of cell B3:
    Please Login or Register  to view this content.
    apply to whole range
    cell O3:
    Please Login or Register  to view this content.
    M3:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Quang PT
    Reply With QuoteRegister To Reply
  6. 04-15-2024, 01:32 AM #6
    Sam Burton
    Sam Burton is offline
    Registered User
    Join Date
    04-13-2024
    Location
    Lincoln
    MS-Off Ver
    MS Office 365
    Posts
    7

    Re: In spec/out of spec formula

    Thanks guys, help is much appreciated
    Reply With QuoteRegister To Reply
  7. 04-16-2024, 05:11 AM #7
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,443

    Re: In spec/out of spec formula

    @Sam Burton You're Welcome. Glad to help . Thank You for the feedback rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need formula for extracting out-of-spec value
    By saziz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-03-2022, 04:21 PM
  2. Formula to find out if "Out of Spec" or "Within Spec"
    By Sashi Jaisingh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2019, 02:05 PM
  3. [SOLVED] formula to define accept/reject for testings of some product with diffrent spec.
    By Pt.purba in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-18-2017, 01:14 PM
  4. [SOLVED] IF spectext in cell X, spec text in cell Y and Spec text in cell Z then Spec text
    By cjohnr1388 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2016, 08:16 AM
  5. What do I use for out of spec in spec
    By lauraem in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-18-2015, 08:38 AM
  6. hew model formula needed....but the spec is in word
    By StuckonExcel123 in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 04:12 PM
  7. [SOLVED] Formula for YTD total of Vac. Hrs. used for spec. employee
    By DebbieDoo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1