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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
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