File Toolbar Missing - filetoolbarmissing
last updated on: 11/10/16 08:45AM
   Troubleshooting Enter a final status based on multiple cells values Error [11/10/16 08:45AM]   
Rate this post  

Enter a final status based on multiple cells values

I have a worksheet that I need to determine a final result based on the status of four cells.
The  four cells can be a number of variations.
Please see example:
Columns ( different variations and the final result)
BO                         BP                              BQ                                BS                                        Final Status
Red                      Red                            Red                               Red                                        Order
Red                      Red                            Red                               Yellow                                    Order
Red                      Red                            Red                              Green                                      OK
Red                      Red                            Yellow                          Red                                         Order
Red                      Red                            Yellow                         Yellow                                       Watch
Red                      Red                            Yellow                         Green                                        OK
Red                      Yellow                       Yellow                          Red or Yellow                         Watch
Red                      Yellow                       Green                          Red or Yellow                          Watch
Yellow                  Red                           Red                              Red                                           Watch
Yellow                  Yellow                      Yellow/Red/Green    Yellow/Red/Green                   Watch

 
Is there a way to produce the Final Result with a macro?
Thank you.

Keys to the Problem Enter a final status based on multiple cells values

Download SmartPCFixer to Fix It (Free)

OK, I've got it all now with that last post.  Thanks for your patience, hopefully this formula will make the wait worth it.
For row 2 (assuming Columns A,B,C and D for BO,BP,BQ and BS)
=IF(OR($A2="Green",AND(COUNTIF($A2:$B2,"Red")=2,$D2="Green")),"OK",IF(OR(COUNTIF($A2:$D2,"RED")=4,AND(COUNTIF($A2:$D2,"Red")=3,OR($C2="Yellow",$D2="Yellow"))),"Order","Watch"))
 
P.S.
as it turns out, =IF(A2="Green","OK,"not ok") was almost it - for the one case where BO is Green, that does result in OK.  But of course other factors got involved later on.
The Rules for "OK"
If BO = Green then Final Status (FS) is OK
If BO and BP = Red AND BS = Green, then FS is OK
Rules for "Order"
If BO, BP, BQ and BS are all Red, FS is "Order"
If there are 3 Red entries in the row AND either BP or BQ is Yellow, FS is Order
Any other conditions are "Watch".
[Edit] Same disclaimer as Jeeped! :)
[2nd Edit] Fixed formula to actually work on row 2 vs 16, and made columns absolute so that it can be copied into other columns without failiing.

Windows Error Reporting - To Fix Enter a final status based on multiple cells values

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Recommended Method to Fix the Problem: Enter a final status based on multiple cells values:

How to Fix Enter a final status based on multiple cells values with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.5.7.0.92,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03,Data Export From Quickbooks To Excel,Date Format In Formula Bar And In The Cell Is Not The Same,Deleted The Snipping Tool,Desktop - Open Program Issues,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: How to Fix Error Error 0x490 on startup,Tech Support: Error 1935 - Unable to install Microsoft Visual C++ 2005 Redistributable KB 2467175,Error 1606.Could not access network location :in32. [Solved],[Anwsered] error 1406 cannot write the value to the registry key,Troubleshoot Envelopes Labels Options Error,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?,Does Log Me In Ignition for my Android with Windows 7 Home Premium?,Download failure for my Blackberry and the process stops during the install,Display settings keep changing when I come back from sleep mode,Downloaded files are not saved



   Trackbacks

      TRACKBACK URL: http://filetoolbarmissing.blogghy.com/trackback/1056414

   Comments

   Post a comment
Name:


Email:


1 + 5 = ?

Please write above the sum of these two integers

Title:


Comments:





About the author

Contact the author
Categories

Latest blog posts
Troubleshooting Enter a final status based on multiple cells values Error
[11/10/16 08:45AM]
Solution Device compatability
[27/09/16 05:11AM]
Troubleshooter of Error Cannot remove a dotted border in a word document
[14/09/16 04:43AM]
Troubleshoot Set Program Access and Defaults IE not listed Error
[13/07/16 05:36AM]
How Can You Fix Notification Area Icon problems
[04/07/16 11:04AM]
Top views posts
Solution Device compatability
[27/09/16 05:11AM] Daily Views 1
Troubleshooting Enter a final status based on multiple cells values Error
[11/10/16 08:45AM] Daily Views 1
Troubleshooting My LAN connection does not allow Internet Explorer to work but the WiFi works fine When I reset the profile both work for a short while Any ideas please Error
[17/05/16 04:19AM] Daily Views 0
My Windows 7 computer is slow How can I improve performance Tech Support
[31/05/16 04:01AM] Daily Views 0
How to Fix Problem No Background Color
[14/06/16 04:57AM] Daily Views 0
Photo Albums








Powered by Blogghy

Page generated in 0.1695 seconds.

Page generated in 0.549 seconds.