Formula Alex
ms execl help in nested if function?
namemathscienceenglish%
john85907583.33333333
alex 52708067.33333333
sam43454042.66666667
i made this formula if i wanted to calculate the grade is this nested formula right because i tried it and it didnt work check it out if(e2>=90,"a"+if (e2>=80,"a",if(e2>=70,"b",if(e2>=60,"c",if(e2>=50,"d","fail")
sry its
if(e2>=90,"a"+if (e2>=80,"a",if(e2>=70,"b",if(e2>=60,"c",if(e2>=50,"d","fail")
Not quite right...
You have a plus (+) sign in there (after "a") that should be a comma. The rest of it looks right...
 |
 Dimension Track Rear Wheel FormulaCartridge Fix Free Alex DA22 Black $84.00 Time Remaining: 1d 12h 6m Buy It Now for only: $84.00 |
 Dimension 700c Formula Freehub 135mm 32h Alex Y2000 Silver $47.00 Time Remaining: 3d 1h 46m Buy It Now for only: $47.00 |
 Dimension Value Series 1 Front Wheel 27 Formula Alex X404 Silver $34.99 Time Remaining: 8d 9h 46m Buy It Now for only: $34.99 |
 Dimension Value Series 1 Front Wheel 700c Formula Alex Y2000 Silver $34.99 Time Remaining: 8d 9h 47m Buy It Now for only: $34.99 |
 Dimension Track Front Wheel 700c Formula Cartridge Alex DA22 Black $66.99 Time Remaining: 8d 13h 54m Buy It Now for only: $66.99 |
 Fixed Gear Track Wheels Formula Alex DH 22 $114.99 Time Remaining: 15d 13h 18m Buy It Now for only: $114.99 |
 Alex SX44 Formula DHG14 DC713 Wheelset 142 mm x 12mm 15mm NEW $168.95 Time Remaining: 16d 14h 32m Buy It Now for only: $168.95 |
 Alex ACE 19 Track Bike Fixed Gear Singlespeed Wheels Wheelset Formula Flip Flop $115.00 Time Remaining: 18d 8h 17m Buy It Now for only: $115.00 |
 Dimension Value Series 1 700c Formula 32h Alex Y2000 Silver $34.20 Time Remaining: 25d 12h 47m Buy It Now for only: $34.20 |
 Dimension Value Series 1 26 Formula 32h Alex Y2000 Silver $36.00 Time Remaining: 25d 12h 47m Buy It Now for only: $36.00 |
 Dimension Track Front Wheel FormulaCartridge Track Alex DA22 Black $70.20 Time Remaining: 25d 12h 47m Buy It Now for only: $70.20 |
 Dimension Value Series 1 26 Formula FH 135mm 32h Alex Y2000 Sil 20 Sil Br $42.30 Time Remaining: 26d 8h 33m Buy It Now for only: $42.30 |
 Dimension Value Series 1 700c Formula FH 130mm 32h Alex Y2000 Sil 20 Sil $43.15 Time Remaining: 26d 9h 58m Buy It Now for only: $43.15 |
 Dimension Value Series 1 700c Formula FW 130mm 32h Alex Y2000 Sil 20 Sil $38.70 Time Remaining: 26d 14h 8m Buy It Now for only: $38.70 |
 Dimension Track Rear Wheel FormulaCartridge Fix Free Alex DA22 Black $75.60 Time Remaining: 26d 17h 11m Buy It Now for only: $75.60 |
 Dimension Value Series 1 26 Formula FW 135mm 32h Alex Y2000 Sil 20 Sil $39.47 Time Remaining: 26d 18h 25m Buy It Now for only: $39.47 |
 Dimension Value Series 1 700c Formula Freehub 135mm 32h Alex Y2000 Sil 20 Sil $43.15 Time Remaining: 26d 19h 49m Buy It Now for only: $43.15 |
 Dimension Track Front Wheel Formula Track Alex DA28 $62.10 Time Remaining: 29d 18h 21m Buy It Now for only: $62.10 |
 Dimension 700c Formula Freehub 130mm 32h Alex Y2000 Silver $47.00 Time Remaining: 29d 23h 31m Buy It Now for only: $47.00 |
| Account limit of 2000 requests per hour exceeded. |