Fast Solution to Problem: currently completing an IF statment however i am capped at 7, how can I get around this

currently completing an IF statment however i am capped at 7, how can I get around this

I am currently completing an IF statment however i am capped at 7, although I have an ever increasing demand on my IF stament ! how can I get around this?
 
The formulea at present is....
 
=IF(I42298=126,"cyclical",IF(I42298=110,"Gas",IF(I42298=120,"void",IF(I42298=100,"Repairs",IF(I42298=121,"repairs",IF(I42298=122,"gas",IF(I42298=123,"void",IF(I42298=124,"Environmental",IF(I42298="125","Defect Recall",IF(I42298="32","Gas Servicing",IF(I42298="28","Gas
Servicing",IF(I42298="38","Gas Servicing",IF(I42298="30","Gas Servicing",IF(I42298="28","Gas Servicing",IF(I42298="31","Gas Servicing",IF(I42298="45","Gas Servicing",IF(I42298="45","Gas Servicing",IF(I42298="49","Gas Servicing",IF(I42298="47","Gas Servicing",IF(I42298="50","Gas
Servicing",IF(I42298="52","Gas Servicing",IF(I42298="48","Gas Servicing",IF(I42298="40","Gas Servicing")))))))))))))))))))))))
 
Thanks

Anwsers to the Problem currently completing an IF statment however i am capped at 7, how can I get around this

Download Error Fixer for Free Now

You could put the following data in a new sheet (eg.
Sheet2, A1:B21):
28 Gas Servicing
30 Gas Servicing
31 Gas Servicing
32 Gas Servicing
38 Gas Servicing
40 Gas Servicing
45 Gas Servicing
47 Gas Servicing
48 Gas Servicing
49 Gas Servicing
50 Gas Servicing
52 Gas Servicing
100 Repairs
110 Gas
120 void
121 repairs
122 gas
123 void
124 Environmental
125 Defect Recall
126 cyclical
then use the formula:
=INDEX(Sheet2!B1:B21,MATCH(I42298,Sheet2!A1:A21,0))
or
=VLOOKUP(I42298,Sheet2!A1:B21,2,FALSE)
 
Alternatively, you could use:
=IF(
    OR(I42298=28,30,31,32,38,40,45,47,48,49,50,52),"Gas Servicing",
    INDEX("Repairs","Gas","void","repairs","gas","void","Environmental","Defect Recall","cyclical",
          MATCH(I42298,100,110,120,121,122,123,124,125,126,0))
   )
Hope that helps.
Cheers
Rich

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Fix the Problem: currently completing an IF statment however i am capped at 7, how can I get around this:

How to Fix currently completing an IF statment however i am capped at 7, how can I get around this with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Troubleshoot:connection status is unknown,the service to detect this status is turned off. how can i fix this problem?,control panel is not working Tech Support,How to Resolve - Crash and reboot when creating a restore point or doing other system restore related things?,Troubleshoot:count formula automatcally,How to Fix Error - CPU powers on then does not boot?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly