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?
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)
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
- Go to Start button.
- Open Control Panel.
- Go to Windows Error Reporting.
- Click on System and Maintenance, then click Problem Reports and Solutions.
- Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
- 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.
- Next, click the Advanced settings link.
- 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.22.214.171.124
,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