Supplier complains.xls
Dear all, I have an excel status report, in which I try to make a formula to show the status, low, medium,high, depending on the drop down list combinations of characteristics choosen in the previous 6 colomns.
Please see attached file.
THis is how formula looks like:
I put up the formula I worked on, first part is working, than when should return medium or high is not working anymore.
If you have anyother idea that I can create this report , or to fix formula, will be very happy to discuss it. Please also take in consideration I need to make graphic after this report afterwards.
Thank you so much and hardly wait for your feed-back!
Bookmarks