T3 fx =IF(R3>=470,"Exceptional",IF(R3

I can't seem to do the nested IF function in column T3.

Extracted text: T3 fx =IF(R3>=470,"Exceptional",IF(R3<><430,"needs improvement")))="" k="" l="" m="" q="" r="" s="" customer="" satisfaction="" 1="" sales="" figures="" are="" expressed="" in="" $1,000s.="" survey="" score="" 1-10="" 2="" salespersonid="" last="" name="" first="" name="" q1sales="" q2sales="" q3sales="" q4sales="" annualsales="" css="" score="" salesscore="" rank="" evaluation="" 3="" e10204078="" adams="" joan="" 93.06="" 96.82="" 97.76="" 99.64="" 387.28="" 9.158="" 478.86="" 2="" exceptional="" e21594943="" barr="" janine="" 94.94="" 74.26="" 96.82="" 97.76="" 363.78="" 8.784="" 451.62="" 19="" e31605018="" bennett="" corey="" 93.06="" 93.06="" 89.30="" 89.30="" 364.72="" 9.473="" 459.45="" 14="" e31898915="" bradshaw="" kathryn="" 100.00="" 74.26="" 86.48="" 98.70="" 359.44="" 8.473="" 444.17="" 22="" 7="" e21001056="" breitfelder="" john="" 100.00="" 100.00="" 93.06="" 91.18="" 384.24="" 9.065="" 474.89="" 3="" 8="" e12104087="" brudnicki="" randall="" 93.06="" 93.06="" 84.60="" 98.70="" 369.42="" 9.345="" 462.87="" 12="" e16106015="" саponigro="" amy="" 72.38="" 100.00="" 87.42="" 88.36="" 348.16="" 8.503="" 433.19="" 24="" 10e81807011="" cebulski="" paul="" 85.54="" 74.26="" 94.94="" 69.56="" 324.30="" 9.349="" 417.79="" 27="" 11="" e77698931="" centry="" lauren="" 93.06="" 84.60="" 85.54="" 87.42="" 350.62="" 8.222="" 432.84="" 25="" 12="" e66506022="" choi="" daisy="" 86.48="" 100.00="" 100.00="" 84.60="" 371.08="" 8.503="" 456.11="" 17="" 13="" e58108010="" correll="" roger="" 95.54="" 90.50="" 88.36="" 99.30="" 373.70="" 9.724="" 470.94="" 5="" 14="" e45104044="" dahlman="" adam="" 90.24="" 85.54="" 93.06="" 88.36="" 357.20="" 8.128="" 438.48="" 23="" 15="" e50406073="" escobar="" isabel="" 93.06="" 93.06="" 93.06="" 93.06="" 372.24="" 8.971="" 461.95="" 13="" 16="" e43996918="" goldacker="" patrick="" 95.88="" 97.76="" 91.18="" 90.24="" 375.06="" 8.784="" 462.90="" 10="" 17="" e30201011="" harris="" jennifer="" 100.00="" 94.94="" 74.26="" 96.82="" 366.02="" 9.252="" 458.54="" 15="" 18="" e23401018="" henderson="" shannon="" 95.54="" 97.76="" 96.82="" 94.26="" 384.38="" 8.784="" 472.22="" 4="" 19e11122233="" homan="" kristen="" 96.82="" 89.30="" 87.33="" 94.26="" 367.71="" 8.128="" 448.99="" 20="" 20="" e64301011="" ivers="" susan="" 89.30="" 77.34="" 100.00="" 89.30="" 355.94="" 9.158="" 447.52="" 21="" 21="" e17997945="" jones="" cynthia="" 87.42="" 97.76="" 89.30="" 96.82="" 371.30="" 9.158="" 462.88="" 11="" 22="" e23107057="" lee="" ahn="" 99.64="" 90.24="" 100.00="" 98.70="" 388.58="" 9.158="" 480.16="" 1="" 23="" e26208076="" 24e76701016="" lopez="" allison="" 87.42="" 74.26="" 86.48="" 93.06="" 341.22="" 8.315="" 424.37="" 26="" martinez="" carl="" 86.48="" 93.06="" 95.88="" 98.70="" 374.12="" 9.533="" 469.45="" 25="" e30502016="" meyer="" joseph="" 94.94="" 88.36="" 100.00="" 100.00="" 383.30="" 8.315="" 466.45="" 9="" 26="" e48506067="" nguyen="" john="" 93.06="" 94.94="" 94.94="" 93.06="" 376.00="" 9.158="" 467.58="" 7="" 27e11403044="" pesoli="" adam="" 71.44="" 85.54="" 88.36="" 78.02="" 323.36="" 8.941="" 412.77="" 29="" 28e85005035="" roches="" ted="" 93.06="" 91.18="" 95.88="" 93.06="" 373.18="" 8.503="" 458.21="" 16="" 29="" e46501020="" ruther="" kara="" 93.06="" 96.82="" 97.76="" 74.26="" 361.90="" 9.345="" 455.35="" 18="" 30="" e28380609="" ryan="" yvette="" 72.38="" 100.00="" 68.62="" 94.00="" 335.00="" 8.192="" 416.92="" 28="" jeffery="" tina="" 31="" e32703081="" schmidt="" 93.06="" 92.12="" 99.64="" 82.72="" 367.54="" 9.943="" 466.97="" 8="" 32="" e32703082="" wascher="" 85.88="" 88.76="" 82.72="" 257.36="" 8.443="" 341.79="" 30="">


Extracted text: 9. In cell T3 write a formula (use nested IF function, i.e. IF within IF) that will: show text Exceptional if Joan's SalesScore score was 470 or higher show text Good if Joan's SalesScore score was less than 470 but higher than or equal to 430 show text Needs Improvement is SalesScore score was less than 430