About
There are a lot of functions in excel. Some of them are easy for users while some are not. In consideration of the using frequency of all the functions, we will find that the most difficult ones are IF, AND and OR.
In case of working, we have to use these functions. In a worse case, we usually used in nested structure including 5-6 IF functions , even more, according if — elseif — else structure . And in order to satisfy the input parameter of these IF functions, we have to make more nested structure that was constituted by more AND, OR and NOT functions. In order to stop this nightmare that make us spending hours on, I invent Easy Excel If.
Easy Excel If provides the possibility that is writing Easy Code, named by me, about IF, AND, OR and NOT functions with an elegance, conforming to the human language and a logical way. Meanwhile, the excel code will be automatic generated and copied into the system clipboard. You only need to paste it into excel. By the help of this tool, you can correctly finished a complicated nested function in just several seconds.
Download
For the moment, Easy Excel If is available on the Windows. The Mac OS X version will be published soon.
Download a free trial of a fully functional version of Easy Excel If now. Get Started
How to use
Step 1. Download and Run the Easy Excel If
Download Easy Excel If. If the file you downloaded is a zip archive, uncompress it first. Reach the unzip software here。 And then run the EasyExcelIf.exe. You will see the following screen snap if it run normally .
Step 2. Write your Easy Code
The interface of Easy Excel If is divided into two parts , as shown in screen snap below.
You can write Easy Code in the upper half. The excel code will be automatic generated by Easy Excel If. And it will be shown in the below half.
In Easy Code, we have the following conditional statements:
if statement – executes some code if one condition is true
if…else statement – executes some code if a condition is true and another code if that condition is false
if…elif…else statement – executes different codes for more than two conditions
In Easy Code, we have 3 logical operators are used to combine conditional statements.
| Operator | Name | Example | Result |
| and | And | A1>100 and A1<200 | AND(A1>100, A1<200) |
| or | Or | A1<100 or A1>200 | OR(A1<100, A1>200) |
| not | Not | Not A1 | NOT(A1) |
Step3. Paste excel code to excel
The excel code will be automatic copied into the system clipboard. You only need to paste it into excel.
Example
1. For example, take a look at the IF function in cell D2 below.
Explanation: the AND function above has two arguments separated by a comma (Table, Green or Blue). The AND function returns TRUE if Product equals “Table” and Color equals “Green” or “Blue”. If TRUE, the IF function reduces the price by 50%, if FALSE, the IF function reduces the price by 10%.
Easy code:
if A2="Table" and (B2="green" or B2="Blue") {
0.5*C2
} else {
0.9*C2
}2. For example, take a look at the nested IF formula in cell C2 below.
Explanation: if the score is less than 60, the nested IF formula returns F, if the score is greater than or equal to 60 and less than 70, the formula returns D, if the score is greater than or equal to 70 and less than 80, the formula returns C, if the score is greater than or equal to 80 and less than 90, the formula returns B, else it returns A.
Easy code:
if B2<60 {
"F"
} elif B2<70 {
"D"
} elif B2<80 {
"C"
} elif B2<90 {
"B"
} else {
"A"
}Registration
Last version of Easy Excel If only cost $6.99. Then later, all future updates free. Nothing to pay, ever again!
Contact us
Email: support@easyexcelif.com