𝚃𝚘𝚙 𝙴𝚡𝚌𝚎𝚕 𝙵𝚘𝚛𝚖𝚞𝚕𝚊𝚜 𝙴𝚟𝚎𝚛𝚢 𝙳𝚊𝚝𝚊 𝙰𝚗𝚊𝚕𝚢𝚜𝚝 𝚂𝚑𝚘𝚞𝚕𝚍 𝙺𝚗𝚘𝚠

𝚂𝚄𝙼():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙰𝚍𝚍𝚜 𝚞𝚙 𝚊 𝚛𝚊𝚗𝚐𝚎 𝚘𝚏 𝚗𝚞𝚖𝚋𝚎𝚛𝚜.

𝙴𝚡𝚊𝚖𝚙𝚕𝚎: =𝚂𝚄𝙼(𝐴1:𝐴10)


𝙰𝚅𝙴𝚁𝙰𝙶𝙴():

𝙿𝚞𝚛𝚙𝚘𝚜𝚎: 𝙲𝚊𝚕𝚌𝚞𝚕𝚊𝚝𝚎𝚜 𝚝𝚑𝚎 𝚊𝚌𝐯𝐞𝐫𝐢𝐧𝐠 𝗼𝗳 𝗮 𝗿𝗮𝗻𝗴𝗲 𝗼𝗳 𝗻𝗨𝗺𝗯𝗲𝗿𝗦.

💡 Example: =𝐴𝐵𝐸𝐑𝐴𝐺𝐸(𝐵1:𝐵10)


𝙲𝙾𝙐𝙽𝚃():

💡 Purpose: Counts the number of cells containing numbers.

💡 Example: =𝐶𝐷𝐵(𝐶1:𝐶10)


𝐼𝐹():

💡 Purpose: Returns one value if a condition is true, and another if false.

💡 Example: =𝐼𝐹(𝐴1 > 10, "Yes", "No")


𝐕𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first column and returns a value in the same row from another column.

💡 Example: =𝐕𝐋𝐎𝐎𝐊𝐔𝐏(𝐷1, 𝐴1:𝐵10, 2, FALSE)


𝐇𝐋𝐎𝐎𝐊𝐔𝐏():

💡 Purpose: Searches for a value in the first row and returns a value in the same column from another row.

💡 Example: =𝐇𝐋𝐎𝐎𝐊𝐔𝐏("Sales", A1:F5, 3, FALSE)


𝐼𝐍𝐃𝐄𝐗():

💡 Purpose: Returns the value of a cell based on row and column numbers.

💡 Example: =𝐼𝐍𝐃𝐄𝐗(𝐴1:𝐶10, 2, 3)


𝐌𝐀𝐓𝐂𝐇():

💡 Purpose: Searches for a value and returns its position in a range.

💡 Example: =𝐌𝐀𝐓𝐂𝐇("Product B", A1:A10, 0)


𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄() or 𝐂𝐎𝐍𝐂𝐀𝐓():

💡 Purpose: Joins multiple text strings into one.

💡 Example: =𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄(𝐴1, " ", 𝐵1)


𝗧𝗘𝗫𝗧():

💡 Purpose: Formats numbers or dates as text.

💡 Example: =𝗧𝗘𝗫𝗧(𝗔1, "dd/mm/yyyy")

React ❤️ for more