AI Assistant to suggest Google Sheetโ„ข formulas from a description
๊ฐœ๋ฐœ์ž:
์ •๋ณด ์—…๋ฐ์ดํŠธ:2024๋…„ 1์›” 7์ผ
ํ˜ธํ™˜ ๊ธฐ๊ธฐ:
96
๊ฐœ์š”
FormulaBuddy makes your life easier by using AI to quickly generate Excel or Google Sheetโ„ข formulas from your text instructions. With FormulaBuddy, you do not need to put effort into building formulas on your own from scratch. 

Letโ€™s say you have a query: โ€œHow do I tell excel that anytime column B has โ€œshoesโ€ in it, to multiply column C by .5 but if itโ€™s anything besides shoes, to multiply by .25?โ€

By entering this query into FormulaBuddy Google Sheetโ„ข Addon, it will give you a direct formula - โ€œ=IF(B1="shoes",C1*.5,C1*.25)โ€

Not only it will generate formulas for you, but it can also give you a feasible explanation for any complex formulas. This will make your life much easier and would help you to save tons of time that you spend on Excel or Google Sheetโ„ข.
์ถ”๊ฐ€์ •๋ณด
๊ฐ€๊ฒฉ์œ ๋ฃŒ ๊ธฐ๋Šฅ์„ ํฌํ•จํ•œ ๋ฌด๋ฃŒ
๊ฐœ๋ฐœ์ž
๋น„์‚ฌ์—…์ž
๊ฐœ์ธ์ •๋ณด์ฒ˜๋ฆฌ๋ฐฉ์นจ
FormulaBuddy for Google Sheetโ„ข์—์„œ ์•„๋ž˜์— ํ‘œ์‹œ๋œ ๊ถŒํ•œ์„ ์š”์ฒญํ•ฉ๋‹ˆ๋‹ค. ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
FormulaBuddy for Google Sheetโ„ข์—์„œ Google ๊ณ„์ •์— ์•ก์„ธ์Šคํ•ด์•ผ ํ•จ
์ด๋ ‡๊ฒŒ ํ•˜๋ฉด FormulaBuddy for Google Sheetโ„ข์—์„œ ๋‹ค์Œ ์ž‘์—…์„ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.
์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์„ค์น˜ ์‹œ ์‚ฌ์šฉํ•œ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ์กฐํšŒ ๋ฐ ๊ด€๋ฆฌ
Google ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋‚ด ๋ฉ”์‹œ์ง€ ๋ฐ ์‚ฌ์ด๋“œ๋ฐ”์— ์™ธ๋ถ€ ์›น ์ฝ˜ํ…์ธ ๋ฅผ ํ‘œ์‹œํ•˜๊ณ  ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.
์™ธ๋ถ€ ์„œ๋น„์Šค์— ์—ฐ๊ฒฐ
๊ตญ๊ฐ€, ์–ธ์–ด, ์‹œ๊ฐ„๋Œ€ ์กฐํšŒ
๊ธฐ๋ณธ Google ๊ณ„์ •์˜ ์ด๋ฉ”์ผ ์ฃผ์†Œ ํ™•์ธ
๊ฐœ์ธ์ •๋ณด(๊ณต๊ฐœ๋กœ ์„ค์ •ํ•œ ๊ฐœ์ธ์ •๋ณด ํฌํ•จ) ๋ณด๊ธฐ
๋ฆฌ๋ทฐ
์–ธ์–ด:
์ •๋ ฌ ๊ธฐ์ค€:
Google์—์„œ๋Š” ๋ฆฌ๋ทฐ๋‚˜ ํ‰์ ์„ ํ™•์ธํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋ฆฌ๋ทฐ์— ๋Œ€ํ•ด ์ž์„ธํžˆ ์•Œ์•„๋ณด๊ธฐ
๋Œ“๊ธ€ ์—†์Œ
๊ฒ€์ƒ‰
๊ฒ€์ƒ‰์–ด ์ง€์šฐ๊ธฐ
๊ฒ€์ƒ‰ ๋‹ซ๊ธฐ
Google ์•ฑ
๊ธฐ๋ณธ ๋ฉ”๋‰ด