You can fix this problem by using ChatGPT (an AI-enabled chatbot). It can transform your text instructions into Excel and Google Sheets formulas in seconds with the help of AI. You write your instructions in plain English and then ask ChatGPT to generate your formula.