= A1 + B1 + C1
= SUM(A1:C1)
SUM/ AVERAGE/ MAX/ MIN/ MEDIAN/ STANDARD DEVIATION(stdev)
Logical Functions
=IF(condition, value if TRUE, [value if FALSE])
=IF(AND(condition1, condition2, ...), value if TRUE, [value if FALSE])
Otherwise, mark it with "No".
AND: true if all conditions are true
OR: true if any condition is true
NOT: reverses true and false
ex)
=IF(OR(MAX(B2:D2)>10, SUM(B2:D2)>20), "Special Order", "No")
If the maximum number of any one fruit exceeds 10 pieces in an order,
or the total order exceeds 20 pieces (all fruit),
then mark it with "Special Order".
Otherwise, mark it with "No".
Conditional Aggregation Functions
COUNTIF
=countif(A:A, "=apple")
SUMIF
Named Ranges
Creating named ranges is a lot more readable and easier to maintain.
How to create named ranges:
Formulas> Define Name
Vlookup: a function that uses a keyword and index to "look up" a value in a table
=VLOOKUP(A2,airline_lookup, 2, FALSE)
1) selecting a cell
2) selecting the range you are referring to -> here I used named ranges
3) Index of the column you are referring to
4) False -> exact match
True -> similar match
Hey there,
ReplyDeleteNice blog
check out our blogs
Top seo company in Delhi Ncr
That's really awesome blog because i found there lot of valuable Information and i am very glad that you share this blog with us.
ReplyDeleteDigital Marketing Consultant in India
Awesome Blog....Looking for the best digital marketing service in mohali? Backup Infotech is a top Digital marketing Service provider company that can provide your business with vast boost traffic for your website. For more details visit backupinfotech
ReplyDeletedigital marketing services
digital marketing in mohali
seo company in mohali
seo services near me
This Blog is very useful.Digital Marketing Company in madhapur
ReplyDeleteFilm108 is one of the best movie promotion and marketing agency in Mumbai, always trying to adapt to innovative approaches for each brand and mark a difference in the digital world.
ReplyDelete