[FREE] Excel/Sheets Formula Generator

JNinja · Mar 31, 2023

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 · Mar 31, 2023

Thanks for the share, will try it out.

JNinja · Mar 31, 2023

tattooedbuddha said:
Thanks for the share, will try it out.

No problem, enjoy.

KriscoVA · Mar 31, 2023

Thanks for the share mate this will come in handy.

irenukii · Mar 31, 2023

Wow, thanks! Sounds good!

JNinja · Mar 31, 2023

KriscoVA said:
Thanks for the share mate this will come in handy.

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

noisymachi · Mar 31, 2023

Thanks for the share! This is very useful for me

kijin · Mar 31, 2023

thanks for share. i needed this these days

JNinja · Apr 1, 2023

noisymachi said:
Thanks for the share! This is very useful for me

No problem. Enjoy the tool.

kijin said:
thanks for share. i needed this these days

Hopefully it will speed things up for you.

xReminisce · Apr 1, 2023

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 · Apr 1, 2023

xReminisce said:
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 · Apr 1, 2023

JNinja said:
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 · Apr 1, 2023

xReminisce said:
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 · Apr 1, 2023

Bookmarked, thanks for the great share.

JNinja · Apr 1, 2023

JasonS said:
Bookmarked, thanks for the great share.

Nice, enjoy!

freshyshops · Apr 1, 2023

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

JNinja · Apr 1, 2023

freshyshops said:
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 · Apr 1, 2023

Great share
I might need this in future

JNinja · Apr 1, 2023

HustleTong said:
Great share
I might need this in future

Definitely something to bookmark for when you need it.

ashu258 · Sep 2, 2023

It shows domain suspended. Site not working.

[FREE] Excel/Sheets Formula Generator

Junior Member

Senior Member

Junior Member

Power Member

Junior Member

Junior Member

Regular Member

Junior Member

Junior Member

Elite Member

Junior Member

Elite Member

Junior Member

Elite Member

Junior Member

Failed to resolve a dispute resolution thread.

Junior Member

Elite Member

Junior Member

Newbie

Main Menu

Marketplace

Making Money

BlackHat World