ShareChat
click to see wallet page
search
Adi. - Author on ShareChat: Funny, Romantic, Videos, Shayari, Quotes
Adi.
562 ने देखा
•
20 दिन पहले
#🙂Positive Thought #😊Feeling happy #free computer typing#excel #computer
🙂Positive Thought - TOP 25 EXCEL FORMULAS Action Formula How to sum a range of numbers? =SUM(A1:A5) How to find an average of numbers? =AVERAGE(A1:A5) How to find the minimum value? =MIN(A1:A5) How to count numbers in the range? =MAX(A1:A5) How to round number to nearest integer =ROUND(4.4444,2) How to do a vertical search? =VL00KUP(1001,A1:D10,0) How to do a vertical or horizontal search? =L00KUP(1001,A1:C10) How to retrieve an item based on location =INDEX(A1:B8,3,2) How to find the position of an item? =MATCH("Apple" ,A1:A8) How to check if a condition is true? =IF(500>100,"Yes",'No") How to sum if cells meet a condition? =SUMIF(A1:A10,">10) How to find average if cells met condition? =AVERAGEIF(A1:A10,">10) How to count cells with any a condition? =COUNTIF(A1:A10,">10) How to join two or more text strings? =CONCAT(A1.C1) How to extract left part of a text string? =LEFT("Excel Fun Class" 5) How to extract right part of a text string? =RIGHT("Excel Fun Class" 5) =LOWER("EXCEL") How to convert text to lowercase? =UPPER("excel") How to convert text to uppercase? =PROPER( "excel fun ") How to convert text to proper case? =TODAY() How to find the current date? How to find the current date and time? =NOW("EXCEL") How to find the current date? =NOW() =NOW() How to find the current date and time? sponsored TOP 25 EXCEL FORMULAS Action Formula How to sum a range of numbers? =SUM(A1:A5) How to find an average of numbers? =AVERAGE(A1:A5) How to find the minimum value? =MIN(A1:A5) How to count numbers in the range? =MAX(A1:A5) How to round number to nearest integer =ROUND(4.4444,2) How to do a vertical search? =VL00KUP(1001,A1:D10,0) How to do a vertical or horizontal search? =L00KUP(1001,A1:C10) How to retrieve an item based on location =INDEX(A1:B8,3,2) How to find the position of an item? =MATCH("Apple" ,A1:A8) How to check if a condition is true? =IF(500>100,"Yes",'No") How to sum if cells meet a condition? =SUMIF(A1:A10,">10) How to find average if cells met condition? =AVERAGEIF(A1:A10,">10) How to count cells with any a condition? =COUNTIF(A1:A10,">10) How to join two or more text strings? =CONCAT(A1.C1) How to extract left part of a text string? =LEFT("Excel Fun Class" 5) How to extract right part of a text string? =RIGHT("Excel Fun Class" 5) =LOWER("EXCEL") How to convert text to lowercase? =UPPER("excel") How to convert text to uppercase? =PROPER( "excel fun ") How to convert text to proper case? =TODAY() How to find the current date? How to find the current date and time? =NOW("EXCEL") How to find the current date? =NOW() =NOW() How to find the current date and time? sponsored - ShareChat