[FREE] Excel/Sheets Formula Generator

[JNinja]

Hey BHW,

Got another good find for a handy AI tool. I've seen ones like this before but they usually require you to pay for an account. This one is free to use without an account or with an account.

How it works is you enter in what you want the Excel or Google Sheets formula to do and it will then generate a custom Formula for you.

Here's the site: https://formulahive.com

Depending on how much time you spend in spreadsheets, this is a life saver. It's pretty crazy how well it does.

Maybe people can share some formulas you managed to come up with.

 

[tattooedbuddha]

Thanks for the share, will try it out.

 

[JNinja]

Thanks for the share, will try it out.

No problem, enjoy.

 

[KriscoVA]

Thanks for the share mate this will come in handy.

 

[irenukii]

Wow, thanks! Sounds good!

 

[JNinja]

Thanks for the share mate this will come in handy.

Sure will Krisco. Definitely if you have to use spreadsheets a lot.

 

[noisymachi]

Thanks for the share! This is very useful for me

 

[kijin]

thanks for share. i needed this these days

 

[JNinja]

Thanks for the share! This is very useful for me

No problem. Enjoy the tool.

thanks for share. i needed this these days

Hopefully it will speed things up for you.

 

[xReminisce]

Simple formulas looks pretty decent but if you know excel, you can probably generate it just as fast rather than typing it out loud (maybe? depends on the person i guess)
a more complex formula or formulas that uses "Table" refs looks pretty buggy


That's not the right formula
Should be,
=Vlookup(AF314, B:AA, 24, 0, FALSE)



Which is still an outdated formula
would be better if you used xlookup to save resources as opposed to vlookup or index/match (but then again, i did tell it to use vlookup so whatever that was on me)


impressive tool nevertheless though, bingchat does the same though, i use it for powerbi formulas sometimes for inspiration or suggestions or reference to formulas when im stuck !
Which brings to the next point, Bing Chat nearly got the entire formula right, was just off by 1 number (it clearly just can't count how many letters between B and Y. (24 not 25). Hence why i said, i use it for reference.

@Bing learn to fucking count, Y column is the 25th column from A:Y but 24th column from B:Y and we were talking about B:Y

 

[JNinja]

Simple formulas looks pretty decent but if you know excel, you can probably generate it just as fast rather than typing it out loud (maybe? depends on the person i guess)
a more complex formula or formulas that uses "Table" refs looks pretty buggy
View attachment 249065

That's not the right formula
Should be,
=Vlookup(AF314, B:AA, 24, 0, FALSE)
View attachment 249066
View attachment 249067
View attachment 249068
Which is still an outdated formula
would be better if you used xlookup to save resources as opposed to vlookup or index/match (but then again, i did tell it to use vlookup so whatever that was on me)
View attachment 249069

impressive tool nevertheless though, bingchat does the same though, i use it for powerbi formulas sometimes for inspiration or suggestions or reference to formulas when im stuck !
Which brings to the next point, Bing Chat nearly got the entire formula right, was just off by 1 number (it clearly just can't count how many letters between B and Y. (24 not 25). Hence why i said, i use it for reference.
View attachment 249070
@Bing learn to fucking count, Y column is the 25th column from A:Y but 24th column from B:Y and we were talking about B:Y
View attachment 249071

You really did your research haha, appreciate it. Hopefully they will keep training their modules and it will get better at the more complicated stuff.

 

[xReminisce]

You really did your research haha, appreciate it. Hopefully they will keep training their modules and it will get better at the more complicated stuff.

really do enjoy tools like this
although I doubt it will ever really replace coding 1:1 but, as a reference or "how to" especially combining or making long complex formulas.
A structured reference that works is soo appreciated since you can't always find them on superuser or reddit etc.

 

[JNinja]

really do enjoy tools like this
although I doubt it will ever really replace coding 1:1 but, as a reference or "how to" especially combining or making long complex formulas.
A structured reference that works is soo appreciated since you can't always find them on superuser or reddit etc.

100 percent. The whole "taking jobs" I see more a media hype. These are tools to help developers and people. Can make things easier or quicker but you'll still need the developer.

 

[JasonS]

Bookmarked, thanks for the great share.

 

[JNinja]

Bookmarked, thanks for the great share.

Nice, enjoy!

 

[freshyshops]

Thanks for the share. It is a time saver for me.

 

[JNinja]

Thanks for the share. It is a time saver for me.

That's awesome. Do you have to do a lot of stuff in Excel?

 

[HustleTong]

Great share
I might need this in future

 

[JNinja]

Great share
I might need this in future

Definitely something to bookmark for when you need it.

 

[ashu258]

It shows domain suspended. Site not working.