Formula for Cell C11 ( Month 8 ) =FORECAST.LINEAR(A11;$B$4:$B$14;$A$4:$A$14) FB Tags : #softexperia #excel_tips
Wingdings Symbols on Excel – Χρήση συμβόλων στο Excel Formula for Column B (B4 & B5) B4=CHAR(40) B5=CHAR(49) FB Tags : #softexperia #excel_tips #symbols / fb : Softexperia.com / www.softexperia.com
You wish to save some money for renovating your house in 5 years. You deposit 2,000 EUR to your saving account at an interest rate of 3% compounded quarterly. Furthermore, you are going to add 100 EUR at the beginning…
Download video : Formulas you should know Download excel file : Formulas you should know SUMIF =SUMIF($A$5:$A$14;C5;$B$5:$B$14) SUM =SUM($C$5:$C$14) CONCATENATE =CONCATENATE(A7;”, “;B7;”, “;D7) VLOOKUP =VLOOKUP(G8;$A$4:$E$14;2;FALSE) UPPER =UPPER(A9) REPT (font MT Extra) ||| =REPT(“|”;D10/50) IF =IF((SUM($C$5:$C$14)>$E$11);”Pass”;”Fail”) AVERAGE =AVERAGE($D$5:$D$14) LEN =LEN(A13) COUNT…
Υπολογισμός επιτοκίου δανείου (ανατοκισμός)
All 3 columns (A,B,C) together with space between them D3=A3&” “&B3&” “&C3 All 3 columns (A,B,C) together without space between them E3=A3&B3&C3 All 3 columns (A,B,C) together with “-” removed in column A and without space between them F3=TRIM(SUBSTITUTE(A3;”-“;””))&B3&C3 Click…
Call Tracker / Ιστορικό τηλεφωνικών κλήσεων και επίλυσης προβλημάτων #softexperia / www.softexperia.com
“Finally, ultimately, you write… for yourself. I mean, I need a public, I need people to play, I need everything else. I’m not working in isolation. But finally the man…is alone. And I have to respond to those criteria which…
Δεν έχει τόσο σημασία πόσο σου πήρε να πάρεις ένα πτυχίο. Κάθε πτυχίο είναι ένα πτυχίο. Δεν έχουν τόσο σημασία οι σχέσεις που χάλασες για να βρεις την αγάπη αλλά η αγάπη που κατάφερες τελικά να βρεις. Το να αγοράσεις…
CTRL+SHIFT+& Applies the outline border to the selected cells CTRL+SHIFT+! Applies the general number format with 2 decimal places CTRL+SHIFT+$ Applies the currency format with two decimal places CTRL+SHIFT+% Applies the percentage format FB Tags : #softexperia #excel_tips_softexperia