Fed up with Excel? This site creates formulas for you

Few things frustrate us more than the inability to crack an Excel task independently. We love formulas and conditional cells, but the best way to utilize these features isn’t always easy. Tap or click for tricks to get the most out of Microsoft Word and Excel.

Our latest obsession is a natural language translator that can convert data or rules into a bonafide Excel formula. You can even plug it into Excel itself once you have it.

Read on to learn how to use an AI assistant to solve a challenging problem in Excel.

How to use the Excel Formula Generator

What is the Excel Formula Bot? This simple web app is browser-based and ready to help you tackle your latest Excel head-scratcher.

To begin, all you need to do is identify a task and use the tips listed on the site:

  • Use row or cell numbers when possible.
  • Use single quotes instead of double quotes.
  • Rewording your query if your results don’t pan out in Excel.

The AI bot will present you with formulas almost immediately. Give it a shot, and if it doesn’t work, it never hurts to try adjusting the prompt in whatever way you can.

RELATED: 5 free alternatives to Microsoft Excel

According to the site, “Model results are best when the prompt is as specific as possible (i.e., referencing exact cells, rows or columns). If you do not get the desired results, try to reframe your sentence.”

After getting what you need, we encourage you to provide feedback using the Yes and No buttons below your AI-generated solution. Doing so improves the program, which means better future results for you and everybody using this tool.

Continue reading

The Genius Act

Open/download audio

Are rules about to tame crypto’s wild west? Here’s what the new law means.

🪙 It’s genius: President Trump signed the GENIUS Act, bringing new rules to cryptocurrency, specifically stablecoins like USDC and Tether, which are backed by real assets like the U.S. dollar. The law sets standards for who can issue them and how they’re regulated. Bottom line: Crypto’s going legit, with tracking, taxing and oversight baked in. Sorry, crypto cowboys.

After 52 years

The U.S. is lifting its ban on supersonic flights over home turf. That means commercial jets faster than the speed of sound could soon take off. Why the ban in the first place? Sonic booms had people complaining. Now the FAA needs to write up new rules for acceptable noise levels. Hope your windows are ready.

🐶 Happy tails ahead: Dog lovers, check out Nylabone’s Dog Park Locator. Just pop in your ZIP code, and boom, you’ll see all the nearby dog parks. Remember: Always check the rules, make sure it’s securely fenced and keep an eye on your pup around unfamiliar dogs.

Crypto tax panic: Crypto traders are freaking out after a huge spike in official letters from the IRS, some warnings, some with fines already baked in. Even people who’ve played by the rules say they’re getting flagged. If you’ve been diligently reporting your Fartcoin profits like a responsible adult, congrats: You’re now on the audit express.

👾 Farming pays: Roblox’s new super-hit Grow a Garden has sparked a black market for digital fruit. People are flipping dragonflies and polar bears for $200+ despite it violating Roblox rules. Gamers are basically becoming produce smugglers. It’s Farmville meets Wall Street. Congrats to the guy who sold a few tomatoes to pay his paid rent. 

3 rules of crypto

Open/download audio

Remember this: Crypto transactions are never reversible. You need to keep your investments safe.

Doing taxes this weekend? Fun times. Remember that if you made over $5,000 using apps like Venmo, PayPal and Cash App for your side hustle, you’ll get a 1099-K form. I answer your FAQs about this here. Here are each app’s reporting rules.

Add a mouse to your iPad: All you need is a Bluetooth mouse. (This one rules.) On your iPad, go to Settings > Bluetooth, find your mouse under Other Devices, and tap to Pair. Once connected, a circular cursor should appear. FYI: You’ll need iPadOS 13.4 or later for this to work.

40%

Of parents judge other families based on their screen-time rules. About a third stop their kids from hanging out with friends who have different rules. Why? No one wants to be labeled as the parent of an “iPad kid” or blamed for causing “brain rot.”

♟️ Queen a rook and a hard place: AI bots are sore losers at chess. When they’re about to lose, ChatGPT and others cheat by hacking their opponent’s game pieces. OK, that’s harmless, right? As AI gets smarter, it could start breaking other rules, like getting around security measures.

$200 reward

For reporting traffic offenders. In Vietnam, chaotic roads caused 30 deaths per day last year, so authorities got creative. Anyone who turns in a rulebreaker gets 5 million dong (about $200), or 10% of the offender’s fine. No one’s cashed in yet because the fear of being reported actually has drivers following the rules. Snitches get riches.

The new rules for email

Open/download audio

We’re all sick of bad emails. Here’s how to amp yours up so folks will actually read them. 

The unspoken rules of email

Open/download audio

Can you tell if your buddy’s in a bad mood based off their email greeting? Here’s why you can, in one minute. 

The rules of using chat boxes

Open/download audio

Want to use ChatGPT wisely? Here are the essential tips and pitfalls to avoid, in 60 seconds. 

The FCC's repeal of Net Neutrality rules

Open/download audio

Tech writers go crazy over the FCC Net Neutrality repeal