• এক্সেলে SUM ফাংশনের কাজ কী?
- এক্সেলে SUM ফাংশন একটি বহুল ব্যবহৃত ফাংশন যা নির্দিষ্ট সংখ্যার সমষ্টি গণনা করতে ব্যবহৃত হয়।
- এটি বিভিন্ন সংখ্যাকে যোগ করার জন্য স্বয়ংক্রিয়ভাবে কাজ করে এবং ব্যবহারকারীকে ম্যানুয়ালি যোগফল বের করার ঝামেলা থেকে মুক্তি দেয়।
=SUM(A1:A5)
এটি A1 থেকে A5 পর্যন্ত সকল সংখ্যার যোগফল নির্ণয় করবে।
1. Basic Mathematical Functions:
SUM(range): Adds up all numbers in a range.
AVERAGE(range): Calculates the average (arithmetic mean).
MIN(range): Returns the smallest number in a range.
MAX(range): Returns the largest number in a range.
ROUND(number, num_digits): Rounds a number to a specified number of digits.
2. Logical Functions:
IF(condition, value_if_true, value_if_false): Returns different values based on a condition.
AND(condition1, condition2, ...): Returns TRUE if all conditions are met.
OR(condition1, condition2, ...): Returns TRUE if at least one condition is met.
NOT(condition): Reverses the result of a logical test.
3. Lookup & Reference Functions:
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]): Searches for a value in the first column of a range and returns a corresponding value from another column.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]): Works like VLOOKUP but searches in a row instead of a column.
INDEX(array, row_num, [column_num]): Returns the value at a given row and column in a range.
MATCH(lookup_value, lookup_array, [match_type]): Returns the position of a value in a range.
4. Text Functions:
LEFT(text, num_chars): Extracts a specific number of characters from the left side of a text string.
RIGHT(text, num_chars): Extracts a specific number of characters from the right side.
MID(text, start_num, num_chars): Extracts a substring from a text string.
LEN(text): Returns the length of a text string.
CONCATENATE(text1, text2, ...) or TEXTJOIN(delimiter, ignore_empty, text1, text2, ...): Joins multiple text values into one.
SUBSTITUTE(text, old_text, new_text): Replaces part of a text string.
5. Date & Time Functions:
TODAY(): Returns the current date.
NOW(): Returns the current date and time.
YEAR(date), MONTH(date), DAY(date): Extracts the year, month, or day from a date.
DATEDIF(start_date, end_date, unit): Calculates the difference between two dates in days, months, or years.
EOMONTH(start_date, months): Returns the last day of the month after adding a specified number of months.
6. Financial Functions:
PV(rate, nper, pmt, [fv], [type]): Calculates the present value of an investment.
FV(rate, nper, pmt, [pv], [type]): Calculates the future value of an investment.
PMT(rate, nper, pv, [fv], [type]): Calculates the payment for a loan based on constant payments and interest rates.
7. Statistical Functions:
COUNT(range): Counts the number of numeric values in a range.
COUNTA(range): Counts the number of non-empty cells in a range.
COUNTIF(range, criteria): Counts cells that meet a specified condition.
RANK(number, ref, [order]): Returns the rank of a number in a list.
8. Error Handling Functions:
IFERROR(value, value_if_error): Returns a custom value if the formula results in an error.
ISERROR(value): Checks if a value results in an error.
সূত্র: microsoft.