Hello, please help on this.
1.png
My report is with
Nominal ; Maximum ; Minimum ; Result
I would like to do PASS/FAIL macro according to the Result based on Nominal, Maximum & Minimum.
Prefer the PASS to be green fill color, while FAIL to be red fill color.
What constitutes a pass and a fail???
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Attachment 800059
Something like this. Example,
Nominal: 1.5
Upper & Lower or Maximum & Minimum Limit: +/-0.5
Result: 0.9 (< would like excel to do this for me, PASS or FAIL)
Last edited by AliGW; 10-11-2022 at 05:25 AM. Reason: Please DON'T quote unnecessarily!
Yes, but how does Excel know whether 0.9 ias a pass or a fail? You haven't even told me what it is.
It's fail.
Nominal: 1.5 +/-0.5
Upper Limit: 2.0
Lower Limit: 1.0
Fail if the result is under 1.0 or over 2.0+
Pass if the result is between 1.0 ~ 2.0
This is just an example. So, would like see a macro where it can show me pass/fail of the result with nominal+upper+lower limit...
Last edited by AliGW; 10-11-2022 at 05:33 AM. Reason: Please DON'T quote unnecessarily!
WHY is it a FAIL? What's the calculation??? No idea how you are manipulating the figures to arrive at PASS or FAIL - you still have not defined what constitutes each.
Life's too short - I'm out, sorry.
Isn't the Pass/Fail just a formula like this?
Formula:
Please Login or Register to view this content.
with some conditional formatting?
Nominal: 3.708 (+0.055 / -0)
Result: 3.736
It should be PASS Result.
Why it shows FAIL instead?
Attachment 800234
Even I add in '+0.05 & '-0, still the same issue.
Attachment 800235
Please help on this, thanks.
D2-G2 = 3.708-3.736= -0.028 which is <F2 (value 0), thus the AND function returns FALSE thus " FAIL"
Is there any other function code to correct for this?Originally Posted by Pepe Le Mokko
Attachment 800238
@Linuxya
TWO forum rules broken in quick succession: please read the forum rules BEFORE posting here again.
@Linuxya Good luck with your query
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks