App Icon
Ablebits
•  64,463
Overview
An intuitive way to build and edit multiple Google Sheets IF statements.
This add-on eases the entire process of creating and editing Google Sheets IF formulas. No matter how strong your formula-building skills are, this user-friendly interface handles the correct syntax on its own. Just fill in blanks with data and let the tool build the outcome formula for you.

ONE ARGUMENT PER LINE
Each part of the formula takes a separate line so you could see clearly where to put the logical expression (IF / IF AND / IF OR) and where its results (THEN/ELSE).

IF OR and IF AND – MULTIPLE CONDITIONS
Have the tool check all criteria together or each one separately in one go.

SIMPLIFIED DATA ENTRY
There's no 'special' way to enter dates, time, booleans, currency, etc. Type them as you do in cells, and the tool will recognize them automatically.

NESTED IFs in ONE GOOGLE SHEETS FORMULA
Fill in as many rules to check against and as many corresponding results as you need within one formula. It is the add-ons job now to collect everything into one working formula.

READY-MADE COMPARISON OPERATORS
All logical operators used to create conditions are collected in one list. Just pick one from the drop-down based on your logical expression.

EXISTING IF STATEMENTS RECOGNITION
Run IF Formula Builder from a cell with a Google Sheets IF formula, and the add-on will split its part for easier review and editing.

180 DAYS OF FREE USE

Fully functional 180-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions please post them here: https://www.ablebits.com/docs/google-sheets-if-then-builder/
We'll be happy to assist!

IF Formula Builder is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
Reviews
Language:
Sort by:
Profile Picture
Nelio Batista
April 14, 2021
It doesn't allow to address the cell number. Says: "Address not in range" Can you help me?
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
April 15, 2021
Hello Nelio, Please email our support team with the screenshot of the error, we'll do our best to help.
Profile Picture
Pretty Wild World
March 29, 2021
It says there's a malware
Is this review helpful?
Yes
No
Profile Pciture
Ablebits team
March 30, 2021
Hello Evan, We can assure you that it's impossible. All our codes are being verified by the Google team before being published on their servers. If you're getting some messages or notifications, please send them to our support team – we'll help you figure the problem out.
Profile Picture
Neil Chudgar
March 26, 2021
I have been looking for something that does EXACTLY THIS for YEARS. Thank you, thank you, thank you. You've saved me hours of work.
Is this review helpful?
Yes
No
Profile Picture
Steven Durham
November 7, 2020
Thank you! After wasting an hour on Google's own documentation, and several otherwise helpful resources, NADA. This is amazing! Every condition I normally use was included. Wonderfully simple interface, and it even works within the Edge browser.
Is this review helpful?
Yes
No
Profile Picture
Irina Tereshenkova
July 30, 2020
thank you for this tool, really helps solving everyday tasks faster:)
Is this review helpful?
Yes
No
Profile Picture
Alexei Kovalev
July 24, 2020
Everything works great! It is sooo much easier now to use if formulas -- i don't even need to think (almost ;D)
Is this review helpful?
Yes
No
Profile Picture
A User of IF Formula Builder
June 22, 2020
add on installed, but did not start.
Is this review helpful?
Yes
No
Profile Pciture
A user of IF Formula Builder
June 23, 2020
Thank you for reporting a problem. Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. Please sign out and log in only under the account you used to grant permissions to the add-on and try to run it again. If this doesn't help, please email us to support[at]ablebits[dot]com, we willl help you resolve the issue.
Profile Picture
A User of IF Formula Builder
June 8, 2020
It put my formula in order! Thanks.
Is this review helpful?
Yes
No
1-8 of 8
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu