The IF function is one of the most popular and useful functions in Excel. You use an IF statement to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met.
In this tutorial, we are going to learn the syntax and common usages of Excel IF function, and then will have a closer look at formula examples that will hopefully prove helpful both to beginners and experienced Excel users.
The IF function is one of Excel's logical functions that evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE.
The syntax for Excel IF is as follows:
As you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional.
For example, your logical test can be expressed as or B1="sold", B1<12/1/2014, B1=10 or B1>10.
For example, the following formula will return the text "Good" if a value in cell B1 is greater than 10: =IF(B1>10, "Good")
For example, if you add "Bad" as the third parameter to the above formula, it will return the text "Good" if a value in cell B1 is greater than 10, otherwise, it will return "Bad": =IF(B1>10, "Good", "Bad")
Though the last two parameters of the IF function are optional, your formula may produce unexpected results if you don't know the underlying logic beneath the hood.
If the value_if_true argument is omitted in your Excel IF formula (i.e. there is only a comma following logical_test), the IF function returns zero (0) when the condition is met. Here is an example of such a formula: =IF(B1>10,, "Bad")
In case you don't want your Excel IF statement to display any value when the condition is met, enter double quotes ("") in the second parameter, like this: =IF(B1>10, "", "Bad")
. Technically, in this case the formula returns an empty string, which is invisible to the user but perceivable to other Excel functions.
The following screenshot demonstrates the above approaches in action, and the second one seems to be more sensible:
If you don't care what happens when the specified condition is not met, you can omit the 3rd parameter in your Excel IF formulas, which will result in the following.
If the logical test evaluates to FALSE and the value_if_false
parameter is omitted (there is just a closing bracket after the value_if_true
argument), the IF function returns the logical value FALSE. It's a bit unexpected, isn't it? Here is an example of such a formula: =IF(B1>10, "Good")
Putting a comma after the value_if_true argument forces your IF statement to return 0, which doesn't make much sense either: =IF(B1>10, "Good",)
And again, the most reasonable approach is to put "" in the third argument, in this case you will have empty cells when the condition is not met: =IF(B1>10, "Good", "")
For your Excel IF formula to display the logical values TRUE and FALSE when the specified condition is met and not met, respectively, type TRUE in the value_if_true
argument. The value_if_false
parameter can be FALSE or omitted. Here's a formula example:
=IF(B1>10, TRUE, FALSE)
or
=IF(B1>10, TRUE)
If you want "TRUE" and "FALSE" to be usual text values, enclose them in "double quotes". In this case, the returned values will be aligned left and formatted as General. No Excel formula will recognize such "TRUE" and "FALSE" text as logical values.
Instead of returning certain values, you can get your IF formula to test the specified condition, perform a corresponding math operation and return a value based on the result. You do this by using arithmetic operators or other Excel functions in the value_if_true
and /or value_if_false
arguments. Here are just a couple of formula examples:
Example 1: =IF(A1>B1, C3*10, C3*5)
The formula compares the values in cells A1 and B1, and if A1 is greater than B1, it multiplies the value in cell C3 by 10, by 5 otherwise.
Example 2: =IF(A1<>B1, SUM(A1:D1), "")
The formula compares the values in cells A1 and B1, and if A1 is not equal to B1, the formula returns the sum of values in cells A1:D1, an empty string otherwise.
Now that you are familiar with the Excel IF function's syntax, let's look at some formula examples and learn how to use IF as a worksheet function in Excel.
The use of the IF function with numeric values is based on using different comparison operators to express your conditions. You will find the full list of logical operators illustrated with formula examples in the table below.
Condition  Operator  Formula Example  Description 
Greater than  >  =IF(A2>5, "OK",) 
If the number in cell A2 is greater than 5, the formula returns "OK"; otherwise 0 is returned. 
Less than  <  =IF(A2<5, "OK", "") 
If the number in cell A2 is less than 5, the formula returns "OK"; an empty string otherwise. 
Equal to  =  =IF(A2=5, "OK", "Wrong number") 
If the number in cell A2 is equal to 5, the formula returns "OK"; otherwise the function displays "Wrong number". 
Not equal to  <>  =IF(A2<>5, "Wrong number", "OK") 
If the number in cell A2 is not equal to 5, the formula returns "Wrong number "; otherwise  "OK". 
Greater than or equal to  >=  =IF(A2>=5, "OK", "Poor") 
If the number in cell A2 is greater than or equal to 5, the formula returns "OK"; otherwise  "Poor". 
Less than or equal to  <=  =IF(A2<=5, "OK", "") 
If the number in cell A2 is less than or equal to 5, the formula returns "OK"; an empty string otherwise. 
The screenshot below demonstrates the IF formula with the "Greater than or equal to" logical operator in action:
Generally, you write an Excel if statement with text using either "equal to" or "not equal to" operator, as demonstrated in a couple of IF examples that follow.
Like the overwhelming majority of Excel functions, IF is caseinsensitive by default. What it means for you is that logical tests for text values do not recognize case in usual IF formulas.
For example, the following IF formula returns either "Yes" or "No" based on the "Delivery Status" (column C):
=IF(C2="delivered", "No", "Yes")
Translated into plain English, the formula tells Excel to return "No" if a cell in column C contains the word "Delivered", otherwise return "Yes". At that, it does not really matter how you type the word "Delivered" in the logical_test argument  "delivered", "Delivered", or "DELIVERED". Nor does it matter whether the word "Delivered" is in lowercase or uppercase in the source table, as illustrated in the screenshot below.
Another way to achieve exactly the same result is to use the "not equal to" operator and swap the value_if_true and value_if_false arguments:
=IF(C2<>"delivered", "Yes", "No")
If you want a casesensitive logical test, use the IF function in combination with EXACT that compares two text strings and returns TRUE if the strings are exactly the same, otherwise it returns FALSE. The EXACT functions is casesensitive, though it ignores formatting differences.
You use IF with EXACT in this way:
=IF(EXACT(C2,"DELIVERED"), "No", "Yes")
Where C is the column to which your logical test applies and "DELIVERED" is the casesensitive text value that needs to be matched exactly.
Naturally, you can also use a cell reference rather than a text value in the 2^{nd} argument of the EXACT function, if you want to.
If you want to base your condition on a partial match rather than exact match, an immediate solution that comes to mind is using wildcard characters (* or ?) in the logical_test argument. However, this simple and obvious approach won't work. Many Excel functions accept wildcards, but regrettably IF is not one of them.
A solution is to use IF in combination with ISNUMBER and SEARCH (caseinsensitive) or FIND (casesensitive) functions.
For example, if No action is required both for "Delivered" and "Out for delivery" items, the following formula will work a treat:
=IF(ISNUMBER(SEARCH("deliv",C2)), "No", "Yes")
We've used the SEARCH function in the above formula since a caseinsensitive match suits better for our data. If you want a casesensitive match, simply replace SEARCH with FIND in this way:
At first sight, it may seem that IF formulas for dates are identical to IF statements for numeric and text values that we've just discussed. Regrettably, it is not so.
Unlike many other Excel functions, IF cannot recognize dates and interprets them as mere text strings, which is why you cannot express your logical test simply as >"11/19/2014" or >11/19/2014. Neither of the above arguments is correct, alas.
To make the Excel IF function recognize a date in your logical test as a date, you have to wrap it in the DATEVALUE function, like this DATEVALUE("11/19/2014"). The complete IF formula may take the following shape:
=IF(C2<DATEVALUE("11/19/2014"), "Completed", "Coming soon")
As illustrated in the screenshot below, this IF formula evaluates the dates in column C and returns "Completed" if a game was played before Nov11. Otherwise, the formula returns "Coming soon".
In case you base your condition on the current date, you can use the TODAY() function in the logical_test argument of your IF formula. For example:
=IF(C2<DATEVALUE("11/19/2014"), "Completed", "Coming soon")
Naturally, the Excel IF function can understand more complex logical tests, as demonstrated in the next example.
Suppose, you want to mark only the dates that occur in more than 30 days from now. In this case, you can express the logical_test argument as A2TODAY()>30. The complete IF formula may be as follows:
=IF(A2TODAY()>30, "Future date", "")
To point out past dates that occurred more than 30 days ago, you can use the following IF formula:
=IF(TODAY()A2>30, "Past date", "")
If you want to have both indications in one column, you will need to use a nested IF function like this:
=IF(A2TODAY()>30, "Future date", IF(TODAY()A2>30, "Past date", ""))
If you want to somehow mark your data based on a certain cell(s) being empty or not empty, you can either:
The table below explains the difference between these two approaches and provides formula example.
Logical test  Description  Formula Example  
Blank cells  =""  Evaluates to TRUE if a specified cell is visually empty, including cells with zero length strings.
Otherwise, evaluates to FALSE. 
=IF(A1="", 0, 1)
Returns 0 if A1 is visually blank. Otherwise returns 1. If A1 contains an empty string, the formula returns 0. 
ISBLANK()  Evaluates to TRUE is a specified cell contains absolutely nothing  no formula, no empty string returned by some other formula.
Otherwise, evaluates to FALSE. 
=IF(ISBLANK(A1), 0, 1)
Returns the results identical to the above formula but treats cells with zero length strings as nonblank cells. That is, if A1 contains an empty string, the formula returns 1. 

Nonblank cells  <>""  Evaluates to TRUE if a specified cell contains some data. Otherwise, evaluates to FALSE.
Cells with zero length strings are considered blank. 
=IF(A1<>"", 1, 0)
Returns 1 if A1 is nonblank; otherwise returns 0. If A1 contains an empty string, the formula returns 0. 
ISBLANK()=FALSE  Evaluates to TRUE if a specified cell is not empty. Otherwise, evaluates to FALSE.
Cells with zero length strings are considered nonblank. 
=IF(ISBLANK(A1)=FALSE, 0, 1)
Works the same as the above formula, but returns 1 if A1 contains an empty string. 
The following example demonstrates blank / nonblank logical test in action.
Suppose, you have a date in column C only if a corresponding game (column B) was played. Then, you can use either of the following IF formulas to mark completed games:
=IF($C2<>"", "Completed", "")
=IF(ISBLANK($C2)=FALSE, "Completed", "")
Since there are no zerolength strings in our table, both formulas will return identical results:
Hopefully, the above examples have helped you understand the general logic of the IF function. In practice, however, you would often want a single IF formula to check multiple conditions, and our next article will show you how to tackle this task. In addition, we will also explore nested IF functions, array IF formulas, IFEFFOR and IFNA functions and more. Please stay tuned and thank you for reading!
3,437 Responses to "Using IF function in Excel: formulas for numbers, text, dates, blank cells"
Assign sequential numeric numbers to each company with IF funciton. If a company name is repeated, it will have the same number.
anyone please slve this?
Hi, I just want the formula like I just evolving each cell's values like marks. If more than (for example >=50) just want to show that value only using.
For example, someone takes 40, 45, 50, 30 evolving all values and retrieve only more than 50 values.
Make sure the brackets are full closed .This will prevent the repetion.
Very Nice, i got it what i wanted thank you.
Hi,
I have D9 = 0 to 2000, I would like to write this formula in C10
if the value of D9 is equal or greater than 15, then cell C10 value will be 15, otherwise, the value of cell C10 should equal to the value in D9
=IF(D9>=15,C10=15,C10=D9)
But, it doesn't give what I want. anyone can help?
Thank you
remove the C10=
hi! like to corelate data in 2 sheets of same excel file. e.g. sheet 1 and sheet 2
I need help to create if or
any formula like
=if(sheet1b2=10,"sheet2A3=Sheet1A3","blank")
plz help
write semicolon instead comma
=IF(Sheet1!B2=10,Sheet1!A3,"")
Put this formula cell A3 of Sheet2.
Can u direct me on the error of my formula? =IF(E22>0)B22+E22
I want it to be cell B22+E22. But ONLY if there is an entry in E22. If E22 hasn't been filled in yet, then I want the formula to be in place but not to SHOW. Much Appreciated!
=IF(E22="","",IF(E22>0,B22+E22))
Can you help me write a formula for the following situation plse.
If A1A2 is less than zero, then show the negative value. If not, then show zero.
Tks
Hi Jaime,
Here you go:
=IF(A1A2<0, A1A2, 0)
Hello Jaime,
The following formula should do the trick for you:
=IF(A1A2<0, A1A2, 0)
Hi Sveetlana Cheusheva
Is it possible that if I enter any text in column"P", "L" should show what is there in "K".
=IF(NOT(ISBLANK(P7)),"0","=K7")
=IF(ISBLANK(P7)),"=K7","0")
Hi Ashwini,
I think you've overthought it :) A simpler formula will work:
=IF(P7<>"", K7, 0)
i using if condition formula it taking only 10 conditions is it only 10 conditions allowed
Can you help me to accurately represent this formula please:
=IF(L4>0612,"High Risk")
Hello Ricardo,
Please try to add quotes so that the formula will look like:
=IF(L4>"0612", "High Risk", "")
IF Early Bird criteria  Customers who want to avail of an Early Bird discount must place their orders on weekdays between 11:45 a.m.  12:00 p.m. (for lunch) or 6:45 p.m.  7:30 p.m. (for dinner).
Write a logical function to find out whether a customer is an early bird. (refer to the 'Early Bird' criteria stated above) In your function, you will have to reference Column E values (day of week) and Column F (time of order) to determine whether customers are early birds. Think about how you will reference the early bird criteria.
If a customer is an early bird, the function should return "Early Bird". Otherwise, the function should return a blank value.
Hi Svetlana,
I am trying to achieve in the formula to show the following:
If the cell drop down is selected with "CB2" is standalone to show "local", if "CB2" & "CB3" (combined) to show "local & far" and if "CB3" to show "far"
How can I achieve this?
TIA
Hi Tia,
There seems to be a problem with the IF(AND()) function. The comment truncates the formula for some reason.
=IF(A1="CB2","LOCAL",IF(AND(A1="CB2",A1="CB3"),"LOCAL & FAR",IF(A1="CB3","FAR","")))
Good Morning,
I am trying an exercise in Excel, we have a sheet some details, however, in the first column A2, have some digit number in the same column digit will be sometime 7, 8, 10 and some case digit numbers with dots then TWO digits.
I am looking for a formula that can help me to write text in the next column............
Example : =IF(A2=(len)8,"NOBILIA",IF(A2=(len)7,"IMPULS",IF(A2=(len)10,"LINEA DÉCOR"))).
Will you please help me with it.
Sincerely yours
Ikram Siddiqui
=IF(LEN(A4)=7,"IMPULS",IF(LEN(A4)=8,"NOBILIA",IF(LEN(A4)=10,"LINEA DECOR","")))
I would like to check a cell for currency format and if its in £ then multiply it by the $ factor to convert it to $s' and if its in $ then leave it in $s'.
example: A1 is the £ to $ currency factor; A2 is the value in £ or $; A3 will be the value of A1 in $s.
I have tried using the IF function, but it will not recognise A1 currency format! I would appreciate some help with this. Many thanks.
Assuming that A1 is 2006 and B1 is 2006
=IF(A1=B1,"True","False") comes up True
but
=IF(A1="2006","True","False") comes up False.
How do I resolve this within a formula since the 2006 is coming from a different formula.
Thanks in advance.
Please show me formula for the below. Thank you!
IF A1 = ABC B1 = 1234; if A1 change to DEF then B1=5678; also if A1 change to GHI then B1=91110
This will only work on 4 letters at a time. I'm assuming you meant ABC = 123 and not 1234. If not this wont work for you.
=IF(MID(A1,1,1)="", "", CODE(UPPER(MID(A1,1,1)))64&""&IF(MID(A1,2,1)="", "", CODE(UPPER(MID(A1,2,1))) 64&""& IF(MID(A1,3,1)="", "", CODE(UPPER(MID(A1,3,1)))64&""& IF(MID(A1,4,1)="", "", CODE(UPPER(MID(A1,4,1)))64))))
Actually I need 6 digits (ABC=123456). So it doesn't work for me! Thanks for trying!
Here is the 6 letter version. To add more numbers you just have to copy everything from IF to the second & and change the number after the A1.
=IF(MID(A1,1,1)="", "", CODE(UPPER(MID(A1,1,1)))64&""&IF(MID(A1,2,1)="", "", CODE(UPPER(MID(A1,2,1))) 64&""& IF(MID(A1,3,1)="", "", CODE(UPPER(MID(A1,3,1)))64&""& IF(MID(A1,4,1)="", "", CODE(UPPER(MID(A1,4,1)))64&""&IF(MID(A1,5,1)="", "", CODE(UPPER(MID(A1,5,1)))64&""&IF(MID(A1,6,1)="", "", CODE(UPPER(MID(A1,6,1)))64))))
Hello Cindy,
Please try to use the formula below to solve your task:
=IF(A1="ABC", 1234, IF(A1="DEF", 5678, IF(A1="GHI", 91110, 0)))
I Tried several times, but it doesn't work. Could you please check and advise again. Thank you!
Hi Cindy,
Try using commas instead of semicolons to separate the arguments (that depends on which character is set as the List Separator in your Regional Settings):
=IF(A1="ABC", 123456, IF(A1="DEF", 5678, IF(A1="GHI", 91110, "")))
Thank you for replying, Cindy.
Most likely it is the delimiter that was causing troubles. Please try this formula instead, it should work:
=IF(A1=”ABC”, 1234, IF(A1=”DEF”, 5678, IF(A1=”GHI”, 91110, 0)))
I've updated the formula in my previous comment as well. Sorry for the confusion.
It works now. Thank you so much!
Glad to hear that, Cindy!
Plz help.....
If i write a number greater then 100 in a cell mistakenly. I want Excel shows an error in that cell.
For example
I write 23 26 56 100 in cells and write mistakenly 105. So i want to show 105 in error.
I would just highlight the whole column and do a Conditional Formatting, Highlight Cell Rules, Greater Than..., 100. Then if the cell is highlighted in red you'll know it's over 100.
Hey,
Your tutorial is great. I am trying to get this nested formula but somehow its only picking up last logical test values. Can you please check & advise.
=IF(B$4>B7<B$3, "Expiring within 2 Weeks", IF(B$3<B7B$2, "Expired", "Valid")))
Regards
What is the cell you're trying to find the value of? B7?
I would trying using IF(AND and doing it that way
Instead of =IF(B4>B7B3,B7<B4),"True","False")
oops, for some reason it got cut off.
Instead of =IF(B4>B7B3,B7<B4),"True","False")
Not sure why it's cutting off so I'll try one more time. "=IF(AND(B7>B3,B7<B4),"True","False")"
Hello Syed,
Here is the updated formula for you:
=IF(AND(B$4 > B7, B7 < B$3), "Expiring within 2 Weeks", IF(AND(B$3 < B7, B7 > B$2), "Expired", "Valid"))
Depending on the city, you will either take a shuttle to/from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4)
Hello,
The formula below should do the job for you:
=IF(E1="Yes", F2, IF(E1="No", F4, ""))
Hi is it possible to do an if formula when a cell is either finance or cash have it do another formula to equal commission?
I need to lock one column so the formula is displayed but do not want the rest of the spreadsheet formulas to show. How can you freeze one column display the formula?
You can remove the "=" so it does not act as a formula.
Hi, I'm trying to write an if/then statement that will represent numerical values. For example, If L48 is greater than L47, then show the value inside L48. If not, show the value inside L47.
I get it to do the yes, no feature, but I'm having trouble getting it to display the value inside of L48.
=IF(L48>L47,L48,L47)
Hi,
I have the conditional formula on my J cell that read as follows: =IF(G3="F2F","1", "0"). G3 has a drop down menu to choose from and one of the options is F2F. How do I add all the ones at the end of my J cells?
Thank you,
Elida
Do you want different values for the different drop down values in G3? Otherwise, use the formula below. This will give you a 1 if G3 has either F2F,F2F2, or F2F3 (replace with whichever is on your list)
=IF(OR(G3="F2F",G3="F2F2",G3="F2F3"),1,0)
i have the following formula:
=if(isblank(A1),"", if(D1<0, weeknum(A1,1),""))
working with this formula:
=if(isblank(J2),"", hlookup(max(#REF!),$R$1:$DD$89,row(J2),false))
to calculate weeks of perfect attendance. However, it has errored out for anything after week 52. how would i fix this to get it to continue past week 52.
I want to use the IF function to test if one cell (say H5) is above zero, then insert a given cell's value (say the numerical value in C5), if the test is false, then insert another cell value (say the numerical value in E5).
=If(H5>0,C5,E5)
Hi,
I need an help to auto calculate the order quantity, if a particular cell is less than eg : 60.
I want to make a one formula in Excel for:
IF 825>the answerthe answer4001,*0.5
if C1, C3 & C5 have "text", how to total them in C10?
(There are approx. 20 cells with or without text that would report to C10.)
Example: C1 = smith. C3 = . C5 = jones. In this case, I want C10 to show the number "2", allowing me to calculate off of that.
Thanks in advance!
Hi James,
To count cells with text, you can use the COUNTIF function with "*" as the criteria. For example:
=COUNTIF(C1:C9, "*")
Please help me build a formula as follows:
if A1 contains A,B or D then it is CLOSED, if A1 contain C then it is OPEN
thanks
=IF(OR(A1="a",A1="b",A1="d"),"closed",IF(A1="c","open",""))
Should work for your formula.
Hi,
I am trying to have the value of a cell(B2) in Sheet2 populate in Sheet1 cell(B3). I thought I could do ='Sheet2'!B2, but when there is no data in Sheet2 B2 the value populates as 0 in B3, I would like it to remain blank.
=IF(Sheet2!B2=0,"",Sheet2!B2)
That should work.
Thank you! Works like a charm!
I'm trying to get an if, then formula to generate a number in a cell if the adjacent cell is a certain letter (for GPA calculations), but i keep getting a value error message. Here is what I wrote: =IF(C3="A",4,IF(C3="b",3,IF(C3"c",2,IF(C3="D",1,IF(C3="F",0)))))
That formula works except for when the value is "C".
Change the "" into "=".
I have a spreadsheet, with multiple tabs I need to be able to Concatenate a text cell (A3) with a date cell(B3) on a report form, but be blank when the date cell (B3) is empty. this is what I have so Far.
=IF(AND(NOT(ISBLANK('Super(No7)'!A3))*NOT(ISBLANK('Super(No7)'!B3))),CONCATENATE('Super(No7)'!A3&""&TEXT('Super(No7)'!B3,"DD/MM/YYYY"),"")).
The above formula works until I add the &TEXT& bit then it returns FALSE. can anyone help please.
Please i need you assistance to building formula as follows:
if A1 contains specific text, A OR B OR C = CLOSED
if A1 contains specific text, C = OPEN
Many Thanks.
Id like to ask how to use if function or whatever easy function can be used should I want to display the percentage in a cell if a condition has been met. The condition is if all specified range of cells contains any values like a word or date. Lets just say that cell A1 will display the percentage of completion if cells ranging from A2,A3,A4,A5,A6 contains a value like yes or no or a date.
Hi Jason,
It's not clear how you calculate the percentage of completion, but the idea is to count nonempty cells in the range A2:A6, and if the count is equal to 6, display the percentage, otherwise return an empty string:
=IF(COUNTIF(A2:A6, "<>"&"")=5, percentage formula, "")
Hi
I have forgotten how to repeat a certain set of numbers for a spreadsheet.
For example i have a list of 3 items and i want the IF function to repeat as 123123 etc.
I have put 3 in the A1 cell and the number 1 in A2.
Thanks
what is the formula for interval,
fill the cell outstanding if score 4.5 to 5
fill the cell V.Good if the score between 3.5 to 4.4, and so on..
i tried to make rounding but it doesn't work if the number not whole even after rounding
This one should work. You can change the text results to whichever you think fits better.
=IF(E5>=4.5,"OUTSTANDING",IF(AND(E5>=3.5,E5=2.5,E5=1.5,E5<2.5),"SATISFACTORY",IF(E5<1.5,"FAIL","")))))
HI, May u help me with this situation?i cant get the right formula for that 0 or negative figure is equal to 0
0 or negative =0
>0 10% = 1
>10% = 2
i have this as my current =IF(G5>10,"2",IF(G5<=10,"1",IF(G5<0,)))
=IF(G7>10,2,IF(AND(G70),1,IF(G7=0,0,"")))
Hope that helps.
=IF(G5>10,2,IF(AND(G50),1,IF(G5=0,0,"")))
Sorry, the original formula is broken, not sure why it did not paste properly.
Sorry, guys, our blog engine sometimes breaks formulas in ">" and "<" symbols.
If my understanding of the task is correct, this formula should work a treat:
=IF(G5>10, 2, IF(G5>0, 1, 0))
=IF(G5>10,2,IF(AND ( G5 0),1,IF(G5=0,0,"")))
The website seems to break the formula... I tried adding spaces to see if it will work...
It seems the IF(AND( function is breaking the formula.
=IF(G5>10,2,
IF(AND[G50],1,
IF(G5=0,0,"")))
Hello, how do I make an if statement see the text in a cell and not a reference? In Cell F2 the value is "T19" I want to say, if F2 = T19 than "A19" with A19 being text not a reference.
Hi Lee,
=IF(F2="T19","A19","")
Is that what you meant?