ShareChat
click to see wallet page
search
Pankaj kumar - Author on ShareChat: Funny, Romantic, Videos, Shayari, Quotes
Pankaj kumar
1.1K ने देखा
•
#excel #MS Excel grade formula #excel formula #excel formula list #EXCEL DAILY FORMULA SHORT CUT
excel - EXCEL FORMULAS CHEAT SHEET Basic Arithmetic Common Functions Addition = 41+81 SUM(AI:A1o)l = 41.81 SUM Subtraction = 1-B1 41+81 AVERAGE AVERAGE(A1:A10) Multiplication = A1+81 COUNT COUNT(A1:A10) Division A1/81 COUNTA COUNTA(A1:A10| MAX(A1:A1O) MAX Logical Functions MIN MIN(41:410| IF(A1>50, "Pass, "Fail") IF = Lookup & Reference AND = AND(A1>50, B1>50) OR(A1>50, 81>.50) VLOOKUP = VLOOKUP(A1,Table,2,FALSE) OR = IFERROR = IFERROR(A1/81,0| VLOOKUP(A1,A;A;B:B) XLOOKUP INDEX(A ;A,5) INDEX = Conditional Functions MATCH = MATCH(AL,A;A,O) SUMIF = SUMIF(A.A,'>100"| Text Functions COUNTIF = COUNTIFIA,A,>50' ) LEFT(A1,4) SUMIFS = SUMIFS(C;C,A,A, '{ast' B:B '>100"| LEFT = MID(A1,2,5) COUNTIFS = COUNTIFS(A,A '>50',8.8, 'Yes") MID = LEN = LEN(A1) Date & Time CONCAT = CONCAT(A1,' ,81) TODAY TODAY() Financial (Basic) DATEDIF(A1,81'd') DATEDIF YEAR = YEARA1) PMT = PMT(mte,nper;pv) MONTH = MONTH(A1) NPVrate,A1,A10) NPV EXCEL FORMULAS CHEAT SHEET Basic Arithmetic Common Functions Addition = 41+81 SUM(AI:A1o)l = 41.81 SUM Subtraction = 1-B1 41+81 AVERAGE AVERAGE(A1:A10) Multiplication = A1+81 COUNT COUNT(A1:A10) Division A1/81 COUNTA COUNTA(A1:A10| MAX(A1:A1O) MAX Logical Functions MIN MIN(41:410| IF(A1>50, "Pass, "Fail") IF = Lookup & Reference AND = AND(A1>50, B1>50) OR(A1>50, 81>.50) VLOOKUP = VLOOKUP(A1,Table,2,FALSE) OR = IFERROR = IFERROR(A1/81,0| VLOOKUP(A1,A;A;B:B) XLOOKUP INDEX(A ;A,5) INDEX = Conditional Functions MATCH = MATCH(AL,A;A,O) SUMIF = SUMIF(A.A,'>100"| Text Functions COUNTIF = COUNTIFIA,A,>50' ) LEFT(A1,4) SUMIFS = SUMIFS(C;C,A,A, '{ast' B:B '>100"| LEFT = MID(A1,2,5) COUNTIFS = COUNTIFS(A,A '>50',8.8, 'Yes") MID = LEN = LEN(A1) Date & Time CONCAT = CONCAT(A1,' ,81) TODAY TODAY() Financial (Basic) DATEDIF(A1,81'd') DATEDIF YEAR = YEARA1) PMT = PMT(mte,nper;pv) MONTH = MONTH(A1) NPVrate,A1,A10) NPV - ShareChat