jeudi 2 février 2017

Using Nested IF statements.

Working in excel 2016. I created a nested IF/then beast. I'll paste it below. The problem is, it is throwing incorrect information sometimes. SO I have 5000 rows and about 20 percent of them are incorrect. I'm not sure how this happened and I need it to be correct as the data then goes into a pivot table which I'm not having much luck with. Any help would be fantastic! Here's the Nested If statement: =IF(F2="HR04-2-G-2-0","Desktops Awaiting Diag",IF(F2="HR06-3-E-2-0","Laptops Awaiting Diag",IF(F2="HR04-2-D-2-0","Tablets Awaiting Diag",IF(F2="HR08-1-F-3-0","Tablets Ready to Go",IF(F2="HR02-1-F-1-0","Parts Need Ordered",IF(F2="RP01-1-A-1-0","Repair Parts Ordered",IF(F2="RP02-1-A-1-0","Repair Parts Recv'd",IF(F2="HR08-1-C-3-0","Cleaning",IF(F2="HR01-1-A-3-0","Inbound Error",IF(F2="RT01-1-A-1-0","Retired",IF(F2="HR04-2-F-3-0","30 Day Hold to Order",IF(F2="RT03-1-A-1-0","Retired Tablet",IF(F2="CART-DI-A-2-0","Inbounds to HW",IF(F2="IMAG-1-A-1-0","HW to Imaging",IF(F2="PACK-1-A-1-0","HW to BOX", IF(F2="HR08-1-D-3-0", "LT Ready",IF(F2="HR08-1-D-4-0","DT Ready")))))))))))))))))

Aucun commentaire:

Enregistrer un commentaire