Hi im trying to setup a excel shet to track my progress

Im tying to make it so if there is a Y in the Pass Cell its worth 7point Merit Cell worth 8 points and the distinction cell is worth 9 point

Then need to add all the point to gether to give me an estmated grade based on the overall score

Iv got this so far but not working U6="Y",7,0

Pass 210-229

Merit 230-249

Distinction 250-259

Distinction*260 and above

My Course Guide.xlsx

Im really stuck greatful for any help