No, it looks pretty messed up (as it did from the start). You still appear to be checking for PENDING later in the formula, which is not necessary, since we are checking for it in the first IF.
I do not like to try to "guess" the logic you want to apply from a formula that contains errors. That involves too many assumptions on are part, which may not be correct.
Can you please lay out (in plain English), all your different conditions/scenarios, and what should happen in each (being sure to include the order/precedence of each condition, if some take priority over others so that the order is important)?
Sure!
The purpose of this cell the formula is in determines the title of the sell rate for labor (i.e. ST, OT, STASB,STLD). When any of those four titles are populated in the formulated cell, the cell next to it populates with the appropriate sell rate (i.e. labor billing rate).
I am trying to automate the process and I can live with the "FALSE" result if D3 and/or D4 are in pending status...it does work with the "FALSE" there...me wanting "PENDING" to show up in the formulated cell is just a cosmetic choice and looks more professional.
When the drop down menus for D3 and D4 are in pending status, that means they are waiting for the estimator to make the choices: (D3)"Are we working over time on this job or not?..(D4) does the job contain contaminates or not???"
D3 default drop down shows "PENDING" status......when you click the drop down your choices are ST or OT
The D4 default drop down shows PENDING status.....when you click the drop down you have the choice of YES or NO.
Once D3 and D4 choices are made, the cell the formula is in will populate with the TITLE of the billing rate.....once that title is in the cell, then the cell right next to it populates with the appropriate billing rate....the billing rate cell is formulated to show the proper rate based on the TITLE of the rate.
Once that billing rate is in place, the estimated labor cost is then calculated throughout the multiple tabs of the estimating work book.
I must show the title of the billing rate and I must show the billing rate
The purpose of all of this is the estimating work book (which I did not build) has multiple tabs, which on each tab, those choices I mentioned above have to be made...and they are EASILY overlooked...and when they are overlooked then the estimate is wrong. I am creating one worksheet where you have to make the choices ONE TIME and I feeds the entire workbook...the choices will never be over looked ever again....so instead of picking the choices 6 times....you now only have to pick them once!
