Who uses Google Sheets often, you know that. | Video published by PY Coding Studio

We can also create our own formula. 😲

Normally, we are familiar with formulas like

= SUM ()

= IF ()

= VLOOKUP ()

But what if the formula we want doesn't exist?

We can use Google Apps Script to write Custom Function. ✨

For example, I want to create a 7% VAT calculation formula.

VAT function (price) {

return price * 0.07;

}

Then come back to Google Sheets and use it now.

= VAT (A2)

We already have our own VAT formula. 🎉

And it's not just VAT.

We can create a lot of formulas based on our work, such as

📅 Date conversion by company format

🔢 Calculate data according to specific conditions.

📝 Format text

🏢 Calculated according to the Logic of work in the organization.

⚙️ Make a specific recipe that Google Sheets doesn't offer.

Who uses Google Sheets to work every day?

Let's study Google Apps Script a little more and know what Google Sheets can do more than you think. 🚀