Task 1 of 3
In B2:B5, show the login (the part before "@").
Lesson theory
TEXTBEFORE(text, "@")returns everything before the delimiter,TEXTAFTEReverything after it. Simpler than LEFT+FIND;LET(name, value, …, calculation)gives names to intermediate results right inside the formula. The formula gets shorter and clearer, and a repeated expression is calculated once.
=LET(disc,E2*0.1,net,E2-disc,ROUND(net*1.08,0))Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.