Remember this: Crypto transactions are never reversible. You need to keep your investments safe.
Fed up with Excel? This site creates formulas for you
© Wdnetagency | Dreamstime.com
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.
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.
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.”
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.
We may earn a commission from purchases, but our recommendations are always objective.
$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
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
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
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
Tech writers go crazy over the FCC Net Neutrality repeal Learn more about your ad choices. Visit megaphone.fm/adchoices