If I Put Something in an Amazon Locker Can I Open It Again if I Left Something Out

iv,336 comments to "Using IF function in Excel: formula examples for numbers, text, dates, blank cells"

Jerome says:

Hello!

Im trying to place multiple functions in single formula, however, I take a roadblock which hopefully we can articulate,

My current formula is:
=IF(I2=G2,"Completed Same Day Plotted",IF(I2G2,"Didn't Complete On Time")))

Legend:
I2 - Date Completed (this data is extracted and vlooked up from another report)
G2 - Plotted Date

The trouble Im encountering is, in the source file of the Engagement Completed, if it appears blank, it will automatically place 0/01/1900 which volition trigger the Completed Earlier Plotted Date.

I'1000 trying to add together a formula that would generate a upshot stating if date is 0/01/1900, it ways the person is currently finishing the class or information technology can be reflecting as "In Progress".

How do I do that?
- Hello!
  Date 0/01/1900 is 0 in engagement format. Therefore, add another status to your formula to check if the value is 0.
  
  =IF(I2=G2,"Completed Same Solar day Plotted",IF(I2 > G2,"Didn't Consummate On Time",IF(I2=0,"In Progress"))))
samuel poracan says:

What is the formula if I want a jail cell to input the post-obit:
If cell is
001 input COGON
002 input DICAYAS
003 input DIWAN
004 input GALAS
005 input GULAYON
006 input LUGDUNGAN
007 input MINAOG
008 input OLINGAN
009 input ESTACA_(POB.)
010 input BIASONG_(POB.)
011 input BARRA_(POB.)
012 input CENTRAL_(POB.)
013 input MIPUTAK_(POB.)
014 input PUNTA
015 input SAN_JOSE
016 input SANGKOL
017 input SANTA_FILOMENA
018 input SICAYAB
019 input SINAMAN
020 input TURNO
021 input SANTA_ISABEL
Lorna Allen says:

Hi I am trying to do the following with dates and it seems the if(or) does not recognise the dates as a value

=If(or(j4="",N2<J4),G4,K4)

J4=date
N2=appointment
G4=£
K4=£

I am basically trying to say if J4 date is blank then use selling toll G4, If month engagement N2 is less than the date J4 then use new selling price K4

any help would be appreciated

Lorna
- Hello!
  If I sympathize your task correctly, attempt the following formula:
  
  =IF(J4="",G4,IF(N2 < J4,K4,""))
David Boyanich says:

This was crawly. I wanted to runway the status of an inventory of items that move from one status to another condition equally they are delivered, used, and readied for removal. This volition assistance in visualizing the lifespan of an object by using nested if statements and using the cell value equally the last "if not true" argument to keep the value nowadays when if has a calculation alter but only on the engagement that the alter takes place. This is interesting. my formula does require the file to exist opened each twenty-four hour period, and then that the date modify will trigger the status calculation in the field. I am using provisional statements to color lawmaking the cells based on the values 1,2 or 3 which is assigned to the prison cell of the date on that line of the object based on its status which is chosen off criteria equally I alter the prison cell information of the objects as they alter condition past inbound the date of the modify of that status, and using a goose egg prison cell to continue unused rows from adding.

Works great.
RK says:

A1 is "Total", B1 is "Not Full", C1 returns "Full"
A2 is "Total", B2 is "Full", C2 returns "Full"
A3 is "One-half Full", B3 is "Full", C3 returns "Half Total"
A4 is "Not Full", B4 is "One-half Total", C4 returns "One-half Full"
A5 is "Non Total", B5 is "Not Total", C5 returns "Not Total"

Equally long as there is Half Full in either col A or col B, col C will return "Half full"

Can anyone help? I can't find a formula to render 3 end results (full/not full/half full)
- Hullo!
  If there are too many conditions, then it is better to use the CHOOSE function instead of the IF function:
  
  =Cull(MATCH(N1,{"Not Total","Half Full","Full"},0) + MATCH(O1,{"Not Full","Half Full","Full"},0)*2, "Non Full","Total","","Half Full","","","Half Full","Full")
  
  I hope it'll exist helpful.
Debashis kar says:

I want to link a prison cell instead of text in value -if -truthful in nested if formulas. what to do
iRFAN says:

Hello i have 4 letter words. In which any discussion starting with letter DL should show every bit LCC otherwise GCC . i am getting the consequence with post-obit formula

=IF(ISNUMBER(SEARCH("DL",B55)), "LCC", "GCC")

but problem is that, if DL is third or fourth letter fifty-fifty though i k getting the result as LCC which i dont want

Kindly help
- Hi!
  Use the IFERROR function to handle "DL" search errors:
  
  =IF(IFERROR(SEARCH("DL",A1),5)=1, "LCC", "GCC")
  
  I hope my advice will help you lot solve your task.
  - iRFAN says:
    
    Thank you Alexander for your promp reply and yes you lot solution has worked perfect
    
    Regards/Irfan
Julian Flanagan says:

Hi,
my very simple formula, continues non to piece of work;
=if(cell ref= Yes,""", "follow upwardly")
for example
=if(e5=yes, "", "follow up")

Aid :)
Thanks Julian
kim hubbard says:

How-do-you-do, can someone help me please? I demand to do an IF office but where true i need information technology to equal another cells contents, is this possible? every time i do it like this =IF(E2>0,"A2","") information technology keeps pulling dorsum the words A2 and not the actual contents of A2... I may be beingness dumb...
- MissusT says:
  
  try: =IF(E2>0,A2," ")
  
  you lot don't need quotes when referencing a jail cell
CARLA POPE-LAWRENCE says:

I desire to utilize an IF part to summate taxes of i% on an income more than 6250 per month.
Sebastián Andrade says:

Hi! I Take the next if statement:
=IF(C4=F4, "[] ", (IF(C4=F5, "[] ", (IF(C4=F6, "[]", "Mistake, please choose a correct platform")))))

Between "[]" I want to put a cell value like this [&D5] but excel is printing the cord "[&D5]".
How tin I insert the value of a prison cell inside a string of an if statement?

Thank your for the post, was so usefully!
- How-do-you-do!
  If I understand your chore correctly, attempt the following formula:
  
  =IF(C4=F4,"["&D5&"] ",(IF(C4=F5,"["&D5&"] ",(IF(C4=F6,"["&D5&"] ","Error, delight choose a correct platform")))))
  
  To learn how to concatenate a cell and symbols using the & operator, read this article.
Rahul Sharma says:

Howdy. I have a query. I want to use a unproblematic IF function and print a true or false result.

=IF(E22>=J22,"Person A won INR ","Person B won INR ")

In the above formula, in the argument "Person A won INR " after INR I desire to impress the value of the consequence (E22-J22)

For instance, if E22 is 200 and J22 is 100, It should print "Person A won INR 100"
- Hullo!
  To concatenate text and a number, use the & operator or CONCATENATE function.
  
  =IF(E22>=J22,"Person A won INR "&J22,"Person B won INR ")
  
  I hope my advice will help yous solve your task.
  - Rahul Sharma says:
    
    Firstly, cheers for the respond.
    
    I am using the below formula but withal it is complaining of invalid name error.
    
    =IF(E22>=J22,"Person A WON INR"& " " &G38,"Person B WON INR"& " " &G39)
    
    G38 has value for E22-J22
    G39 has value for J22-E22.
    
    Could you please aid to point out what is the mistake in the above formula.
    - Hi!
      Unfortunately, I could not replicate your trouble and got an invalid name mistake.
  - Rahul Sharma says:
    
    Please ignore my last reply. Information technology is resolved now. Thanks a lot for the quick response Alexander :)
Rochelle says:

Need a formula for
if C3 = number and then D# = a name

I tin can change or brand a principal of names to pull from
- Hello!
  You can use the VLOOKUP function to extract the name by number. Run across this commodity for examples and instructions.
  I hope information technology'll be helpful. If something is withal unclear, please feel free to ask.
Arley says:

Sir, let me apologize ahead of fourth dimension for the incoherent attempt to describe the problem...

I am attempting to take two columns that comprise specific text (drop down selection) yield a result based on the multiple combination of options. I am trying to get develop a formula that uses the specific text with multiple variations results in generating new text based on the two cells. Looking beneath you tin see there are multiple combinations that volition results in RAC 1, RAC 2, RAC iii, and RAC 4.

In short the goal is to select the probability and Severity rating and so the RAC Code will machine-populate based on the available combinations.

Probability Severity RAC Code
I Catastrophic (A) Frequent RAC 1
I Catastrophic (B) Probable RAC ane
(II) Critical (A) Frequent RAC i
(I) Catastrophic (C) Occasional RAC 2
(I) Catastrophic (D) Seldom RAC 2
(II) Critical (B) Likely RAC 2
(II) Critical (C) Occasional RAC ii
(III) Moderate (A) Frequent RAC 2
(Iii) Moderate (B) Likely RAC 2
(III) Moderate (C) Occasional RAC two
I Catastrophic (E) Unlikely RAC 3
(II) Disquisitional (D) Seldom RAC 3
(IV) Negligible (A) Frequent RAC 3
(Ii) Critical (Eastward) Unlikely RAC 4
(Three) Moderate (D) Seldom RAC 4
(Iii) Moderate (East) Unlikely RAC iv
(IV) Negligible (B) Probable RAC iv
(IV) Negligible (C) Occasional RAC 4
(Iv) Negligible (D) Seldom RAC 4
(4) Negligible (Eastward) Unlikely RAC 4

This was my effort nevertheless it populates the RAC without both cells populated.
=IFS(AND(AND(H2="(I) Catastrophic",I2="(B) Probable"),AND(H2="(I) Catastrophic",I2="(A) Frequent"),OR(H2="(II) Critical",I2="(A) Frequent")),"RAC 1",(OR(AND(H2="(I) Catastrophic",I2="(C) Occasional"),AND(H2="(I) Catastrophic",I2="(D) Seldom"),AND(H2="(Ii) Critical",I2="(B) Likely"),AND(H2="(II) Critical",I2="(C) Occasional"),AND(H2="(Three) Moderate",I2="(A) Frequent"),AND(H2="(Three) Moderate",I2="(B) Probable"),OR(H2="(Three) Moderate",I2="(C) Occasional"))),"RAC 2",(OR(AND(H2="(I) Catastrophic ",I2="(E) Unlikely"),AND(H2="(2) Critical",I2="(D) Seldom"),OR(H2="(IV) Negligible",I2="(A) Frequent "))),"RAC three",(OR(AND(H2="(II) Critical",I2="(Due east) Unlikely"),AND(H2="(Three) Moderate",I2="(D) Seldom"),AND(H2="(Three) Moderate",I2="(E) Unlikely"), AND(H2="(4) Negligible",I2="(B) Probable"),AND(H2="(IV) Negligible",I2="(C) Occasional"),AND(H2="(IV) Negligible",I2="(D) Seldom"),OR(H2="(IV) Negligible",I2="(E) Unlikely "))),"RAC 4")
John Louvis says:

What function I will exist using to perform a nested if condition between 2 excel CHAR role.
- Hi!
  The CHAR part returns a character by its code. What you want to practice with two CHAR functions - I tin can't guess.
Ngalaku says:

Hi Admitting Team,

Thanks for a great article. I have a range of data showing a merchant'southward transactions performed through a platform that we'll call FastExpress cleaved downward in a sample below (the original data has over 10,000 entries):

PAID_LOCAL Status CURRENCY AMOUNT COUNTRY_CODE CARD Company
01/04/2019 success USD 1,956.00 US Mastercard
02/04/2019 failed USD 2,390.57 GH Mastercard
02/04/2019 success USD 1,201.06 GB AmEx
02/04/2019 success USD v,201.06 GB AmEx

The Card visitor takes it fees, FastEx takes theirs and and so pays the merchant
The Bill of fare visitor & FastEx has the beneath fees:

Mastercard = 1% for local transactions (washed in Us) and one.v% for strange transactions if fees are below $200 so ii% and 2.5% respectively for fees equal to or above $200

AmEx = 1.ii% for local transactions (done in U.s.) and 1.7% for foreign transactions if fees are below $200 then ii.two% and ii.7% respectively for fees equal to or above $200

FastEx = 0.8% for local transactions (done in U.s.) and 1.3% for strange transactions if fees are beneath $200 then 1.viii% and ii.3% respectively for fees equal to or above $200

Delight annotation that fees are capped at $180 maximum for local transactions

and would like summate how much is due to pay the Bill of fare Company, how much for FastEx and the net payment to the merchant
Non sure if the IF function would best suit this computation equally every attempt kept getting confusing and complex.

Hoping to hear from you lot.
Thanks!
Maja M says:

How-do-you-do.
I am trying to create a formula with this information:

If Engagement A - Date B (cheque-in and check-out date for guests) are lower than 20.6.2022 or higher than 31.8.2022 the statement is true, value should be "depression" if they are betwixt those dates (so higher than 20.6 and lower than 31.8) then "high".

I tried:
=IF(AND(B4=DATEVALUE("31.8.2022"), D4=DATEVALUE("31.8.2022")), "low", "loftier")
But it doesn't really work. Help would be apreciated.
Cheers in advance.
- How-do-you-do!
  To specify a date, you can use the DATE function:
  
  =IF(AND(B4 > = DATE(2022,half-dozen,22),D4 < = Date(2022,8,31)),"depression","Loftier")
  
  This should solve your task.
Anonimous says:

Howdy! Do y'all have whatever propositions for a formula that would both work for extracting the name and surname from these rows in a singe prison cell

21-Feb-2022 requested by Suvarna, Rashmita21-Feb-2022 completed by dbgURL provided just as well long with the coding to accept
17-Feb-2022 Requested by Chacko, Alphonsa21-Feb-2022 Completed by SPVersion Update Asking
21-Feb-2022: Request past Alonso Nunez, Marta21-February-2022: Completed by BOT

For instance, should extract Suvarna, Rashmita as a consequence from the first row
- Hi!
  The surname is not fifty-fifty a split word. I don't think it can exist washed with a formula.
Talat Nawaz says:

if the corporeality is 350000 than bonus 100 and than corporeality is 351000 per thou 1 plus 350000=100 and 351000= 101, 353000= 103
- Hi!
  Distressing, I don't understand what y'all want to calculate. Explain more.
Naveed says:

I need the formula Like ( Block lawmaking B-218 in canvass 3 times and amount 100 x three = 300 ) now another cell accept dissimilar block code and values i need if block lawmaking B-218 has no payment or not institute then give Outstanding if the all information is at that place then calculate all amount sum 300 notwithstanding these value and cake code in different cell.
Tony says:

Please I would similar to know how I tin can set an automated text on one excel canvass if a value is establish in another sheet. If a value is found in sheet one, so I should go a text equally ''done'' on the other canvass where that value is.
BALDEV M C says:

PLEASE HELP ME ON BELOW MENTIONED FORMULA:-
A B C D Due east F Chiliad
one NO. Proper noun PAN TEL NO. PERSON ADRESS PROOF EMAIL ID
2 1 BALDEV ABCDE12345F 99999 AMIT DDEGE12345C BALDEV@Thousand.COM
3 2 SURESH CDEFG12345A 88888 RAKESH CCCCC12345C SURESH@One thousand.COM
iv 3 AMIT DDEGE12345C 77777 SURESH CDEFG12345A AMIT@One thousand.COM
5 iv DEEPAK AAAAA12345A 66666 MAHESH BBBBB12345B DEEPAK@G.COM
6 five MAHESH BBBBB12345B 55555 DEEPAK AAAAA12345A MAHESH@G.COM
7 6 RAKESH CCCCC12345C 44444 BALDEV ABCDE12345F RAKESH@G.COM

Formula Answer
=VLOOKUP(C2,$C$2:$G$7,iv,Faux) DDEGE12345C

NOTE:- I Neen Respond as BALDEV@G.COM [EMIAL ID]
- Hi!
  I don't understand what formula helps you want. The value DDEGE12345C is in columns 2 and 5 of your range. Is this the trouble?
Chaudhary Hamza Akhtar says:

I am trying to utilize a formula to the prison cell if a specific jail cell contains specific text like D8 contains the total amount of project society and E8 contains the status of club ether it is completed canceled or nether revision. In F8, I want to employ IF Formula in such a fashion that if E8=completed and then it will utilise the formula to get the value of 80% of the D8 Our Actual Turn a profit, rest 20% is our price of work) but if the text is not equal to completed and so the value should be 0. How tin can it be possible? I am trying this formula but getting mistake (=IF(E8=Completed,"(D8/100)*eighty", "0")).

Cheers.
- Sandeep says:
  
  Put the cord to compare in "". Like =IF(E8="Completed",D8*0.8,)
  Try this.
Volition says:

Is it possible to apply IF Function (or what other role) on my case?
If value is less than or equal 0 type "True" but if greater than it will only show the number as is? Thanks
- Hello!
  Yes, you tin apply the IF function.
  
  IF(A1<=0,TRUE,A1)
Shafi says:

Howdy sir,

Project status of Open up and airtight using conditional format was washed. At present i want to conclude all these in a overall projection status like if all closed it shows closed, if whatever one open , it shows Open up...Like that,,,pls help me
- Hullo!
  If I got you right, the formula beneath will aid y'all with your job:
  
  =IF(SUM(--(A2:A20="Open")),"Open","Closed")
David says:

I am trying to fix an IF where information technology cheque a cell to see if an 'Ten' is there. I can fix for it to cheque for numbers, just if I put =IF(A1='X',i,0) it gives me an error lawmaking.
- Hullo!
  I don't really understand what you want to practice. To cheque numbers, y'all need a separate IF formula. Or create a nested IF formula for multiple weather condition, equally described in this guide.
Jonas says:

Hi,

it is possible to write a formula for this task.

In A1 I have text "v:part1:neg:vn:undef:neutr|būti=nebūtina" and and so on everytime with ending "=text". I want that formula would type that "text" into B1. Text in all the lines is different.

Cheers.
- Hello!
  I am not sure I fully understand what you mean. If y'all desire to split a text into cells, read this guide. If I didn't judge, please describe in particular the upshot you want to become.
  - Jonas says:
    
    Hi,
    
    I read that guide but don't have "separate text" option.
    I demand to split the text into cells after equal sign. So if I have a text in cell A1 "v:part1:neg:vn:undef:neutr|būti=nebūtina", I need the word later equal sign to appear in prison cell B1 "nebūtina".
Antoinette de Beer says:

Hi.

I need to do a formula.

I have the post-obit columns:

Status, Date offer accepted, actual start date, Client driven agree, requisition cancel engagement.

In the status column, we have the following on a dropdown list (all different colours)
Filled Non Yet Started
Closed
Did Not Fill
Partially Filled
On Agree
Cancelled

I need to do a formula where it will automatically choose one of the options on the dropdown (above) by inputting a date in the cavalcade and change to that colour on the status column.
- Hello!
  Automatic selection of a value in a driblet-downward list is but possible using a VBA macro.
Ankitkumar Hemraj Dhingra says:

Hi Sir,

I am facing a claiming to come to find a formula for the below effect. I hope if you tin help me sort information technology out.

I have lot of data in word format (its the syllabus for children) and I want to catechumen the same in Excel format to make it attractive to children. I used Left, MID, Right formulas, but the last word some times come incompletes in the sentence, do y'all know what tin can exist done to skip the incomplete word in the end of the sentence and to go that in the next line.

I know it doesn't looks straight forward, but whenever y'all have a solution, it would exist appreciated if you would share it with me. Thanks in accelerate.
- Howdy!
  The information you provided is non enough to understand your case and give you any communication. For me to exist able to assist you ameliorate, please specify which formula yous hateful and describe the trouble in more detail.
Rob Steward says:

Good evening,

I am in grad school and nosotros had a test that asked if the following formula was wrong. =IF($A1="Yes","1","0")

I put this in excel and gave it a set of data under column A and went from row 1-10 using yep and no. The formula worked correctly, however, I am told I was incorrect and the formula wouldn't work because you are non allowed to put quotation marks on numbers in an IF statement.

Is not using quotations on numbers in an IF statement his stance or is it a fact? If it is fact, then why does the formula still work with the given data set?
- Howdy!
  The quotes mean that the number is written as text. Your formula will return the number as text. The numbers in quotes follow the syntax of the IF part and are not an error in using it. Still, go along in heed that with these numbers you will not be able to perform mathematical calculations, since they are already text. Even so, there is no prohibition in Excel to use quotes with numbers.
  - Rob Steward says:
    
    Thanks for your time on the reply. I now understand why I gave the wrong answer.
§ says:

why
=IF(A1;"text";"") - returns "text" if a1 has any information and blank if a1 is blank

simply

=IF(AND(A1;Mean solar day(A1)1);"text";"") - returns "text" if a1 is bare or has data, and bare only if day(a1) is 1

=IF(AND(A1"";Mean solar day(A1)i);"text";"") - works equally intended

what am i missing?
- Hullo!
  Your formulas are not fully written, and so I can't help you lot.
vijay says:

i 6
ii 8
3 12
4 12
5 15
6 18
I want If formula 1st Row Information
second Row Formula Requierd kinldy Share IF formula
GOPI says:

Hai Sir,

i need a formula for Marks to percentage,

if the percentage is below ane% mark is 5

if the percentage is i% to 3% mark is x

if the percentage higher up 3% to 5% marking is 15

if the pct in a higher place v% mark is twenty....
- - gopi says:
    
    Thank you sir,
Flick says:

I'm trying to come with a formula that will input words, and so if a number is below 30 it volition say "within 30 days so if it'due south between 30-365 it will say "within 12 months and anything over 365 volition be blank. so far I can do the first role but I'chiliad not sure how to add together some other condition.

=IF(E6<xxx, "inside 30 days")
Lars says:

I want to brand a formula that goes something similar this

=if(value>blank(G3:L3 add 80 to M3)

Sorry I'k a real novice in excel. :-(

Hope somebody can assist me out.

\Lars
- Hullo!
  Please use the following formula:
  
  =IF(SUM(--(G3:L3<>""))=0,M3+80,0)
  or
  =IF(SUM(--(G3:L3=""))=vi,M3+80,0)
  
  Promise this is what you demand.
jan says:

hello, i am trying to do a formula where the post-obit occurs

if the balance is greater than 37500 (say l,000) then the excess 12500 needs to be multiplied past 40% and the original 37500 needs to be multiplied by 20%

if its less than 37500 then but that balance needs to be multiplied by xx%

i have tried a few IF formulas only they simply do role of the task
- Hello!
  If I got you lot right, the formula below will help you with your chore:
  
  =IF(A1>37500,(A1-37500)*forty%+37500*20%,A1*20%)
Marshall Alfred Opare says:

How practice i return a consequence to exist adept or bad from a list of numbers
- Hi!
  Describe in detail what problem you lot have, and I will effort to help you.
Muhammad adnan says:

Hello,
can anyone help me to set a formula with data validate I have three conditions in my data validation listing Present Absent and Paid Exit which is denoted With P, A, and PL, what I desire when my leave balance is equal to aught and then I select PL then popup message appeared no go out residuum
- Hi!
  You lot cannot get a popup message using the usual Excel formula. Need to apply VBA macro
ANAND KUMAR JHA says:

A B C D
TOTAY

346 INV-0354 30/06/2021 18901.52 =+IF(TODAY-B346>90<180,D346,0)
347 INV-0355 thirty/06/2021 1330.20
348 INV-0356 30/06/2021 2861.l

Please Assist On This Function and suggest me right formula
- Hi!
  You lot can learn more about IF statements with multiple AND/OR weather in Excel in this article on our blog.
  Besides, brand certain you use the TODAY function correctly.
  
  =IF(AND(TODAY()-B346>xc,TODAY()-B346<180),D346,0)
Abraham Crowe says:

I am Trying to Utilize the Value(Text) in Cell Eastward to determine the the status in jail cell I to read (Pass, Fail) based on the Value(numerical) in field G. Example. IF E = Gram, Eight, Quarter, Half and G Numerical Value fits a given field then I = Pass or Fail. The Value in E volition Determine if the Value in G is Truthful. The True/Pass parameters for G will exist Gram >=1.08 ,=3.7, =7.27, =xiv.16, <=xiv.4. Equally long equally Cell 1000 Falls Betwixt these ranges for the appropriate value in Prison cell East then Cell I should evidence Laissez passer. IF exterior these so Fail.
- Hi!
  I'g sad but your clarification doesn't give me a complete agreement of your task.
  Simply conditions >=one.08 ,=3.7, =7.27, =xiv.16, <=14.iv cannot be met at the same time. I recommend leaving ii weather condition: >=1.08, <=14.4
tara says:

I want to write an if formula that if the prison cell has a number >0 to render a sure value, if the jail cell has text to return it as naught.

Example I take a time card Monday = viii , Tuesday= FO, Wednesday = 8, Thursday =viii, Friday = eight. I am trying to say everyday the person works they get an extra 2 minutes of pay. currently I have multiple if functions stating =if cell >0, two,0 but the cell with the FO text is getting the true argument.
- Hello!
  To make up one's mind the content of a cell, you can use the ISNUMBER and ISTEXT functions.
  
  =IF(ISTEXT(A1),0,ii)
  
  or
  
  =IF(ISNUMBER(A1),two,0)
D.B. says:

Hello,

i need a formula, that says: IF =H3-J3>0, and iF =H3-J3<0,121 (so it is ok),
just: IF =H3-J30,121 (then rise or lower the G3 cell so it can be in the parameters from 0 to 0,121).

If this is possible.
- D.B. says:
  
  Something is wrong. So i will send the question in 2 parts.
  
  ane. role
  
  i need a formula, that says: IF =H3-J3>0, and iF =H3-J3<0,121 (and then it is ok).
  - D.B. says:
    
    2. function
    
    just: IF =H3-J30,121 (and then rise or lower the G3 cell so it can be in the parameters from 0 to 0,121).
    - D.B. says:
      
      again it is non expert...grrr
Zilha Pari says:

i need a formula that if prison cell B3 is "A" then put the 5% in jail cell D3????????
- Hi!
  Formula in prison cell D3:
  
  =IF(B3="A",5%,"")
Leah Adams says:

How-do-you-do,

While creating a time sail that will automobile calculate an invoice amount I have tried the above, referencing the "IF formula to perform a math functioning and return a consequence".

My information comes from a drop downwardly list. I want the particular cell to say "ok, if this cell says "client A", and so do this math formula in this other jail cell". The problem is, each of the names in my drib downwardly listing corresponds to a different per centum rate to multiply the payrate past in order to get the bill rate..make sense? So if the worker had x hours working for client A I want to be able to choose customer A from the drop down list, manually enter the pay rate for that employee, and then accept the sheet calculate the OT pay rate, regular bill rate, OT neb rate and total it all at the bottom to show what the invoice should be. I have all of the other work done, I just cannot seem to get past this part, and I wonder if I am trying to go Excel to practice too much with too trivial. Delight help.

Hither is how I have entered the formula.

Customer A Client B Client C pay rate
=IF(AND(OR('Dropdown Lists'!A30,'Dropdown Lists'!A34,'Dropdown Lists'!A50)), N17 + N17*45%)
- Hello!
  Yous can automatically find and insert the interest rate for the selected customer into a cell using the VLOOKUP function, as described in this article.
  I hope this will help, otherwise delight do not hesitate to contact me someday.
David says:

Hello,

Is information technology possible to make a formula so that IF prison cell A is Province ( Ontario, Alberta, Yukon, Manitobia ....) so multiply cell B Number with prison cell C (2%,3%,9%.... ?

basically trying to calculate taxes depending on province.
- Hello!
  You can read recommendations on how to utilize a nested IF function in this commodity.
  
  =IF(A1="Ontario",B1*ii%,IF(A1="Alberta",B1*iii%,""))
  
  You can use the IFS function for multiple conditions:
  
  =IFS(A1="Ontario",B1*2%,A1="Alberta",B1*iii%)
  
  If the province'southward list and percentages are in columns D and E, y'all can notice the percentage you want using the VLOOKUP function:
  
  =B1*VLOOKUP(A1,D1:E10,2,0)
  
  I hope it'll be helpful.
Aria says:

Hello,

Is information technology possible to use a formula that says if CO or CM and then 8?
I'thousand keeping a score at piece of work with my coworkers and how many days they've worked and how many days they've had pto (CO) or medical (CM). i need the formula to piece of work for 30-31 entries per persona (the days of the month) and i need something when i put cm or co in the table to render eight dorsum equally in hours not worked. is information technology possible? am i making whatsoever sense?
- Aria says:
  
  Oh. Forgot to mention. Equally i have 31 columns in a row, if there are more 1 CO to sum them up. for case if i accept three CO and so the answer given should be 24. is it possible?
  - Howdy!
    Pay attention to the COUNTIF office. Please check out this article to learn how to count cells with multiple criteria (OR logic).
    The result you get is multiplied by eight.
    I hope it'll exist helpful.
    - Aria says:
      
      Thank you so much! I managed to arrive work. You're awesome!
Jenn says:

Forecasting spreadsheet: At that place are start and end dates for each projection. I desire the corresponding dated cells to colour fill based on if they fall between the start and finish dates. If I change the appointment, I want it to automatically change the fill. No fill if exterior of dates. Ex: Start ii/25/2021 Finish eight/30/2021. Cells dated 2/25/2021 to viii/30/2021 volition exist filled. If I change date, it volition modify fill.

=IF($K39="TBD",2,IF(AND($L39=AH$1),IF($G39="OH",1,5),0))
Cassandra Acosta says:

I'thou trying to write a formula where if b4 is $14000 and is greater than c4 which is $10000 then the amount in c4 ($10000) needs to exist displayed in d4. Could you lot please offer some assistance.

Cheers
- Hi!
  The formula for your conditions may look like this:
  
  =IF(B4>14000,C4,"")
  
  If B4> 14000, then B4 will always be greater than C4, where 10000 is written. Therefore, the 2nd condition does not make sense.
  You tin can acquire more nearly IF function with multiple conditions in this commodity.
Apprehensive says:

I desire the formula such that value_if_false wouldn't affect other cells when I elevate the formula dowwards
mazlan says:

Hello,

I demand aid in Excel prison cell. I want a upshot from 2 atmospheric condition. if the cell i blazon five the answer is 100 and if i type 10 the anwer is 300 on the same prison cell. how to practise using IF or other formula?
- Howdy!
  If I sympathize correctly, you lot desire to write both the value and the formula in one jail cell. It's impossible. Yous demand to use a VBA macro. If the formula and the value 5 or 10 are in different cells, employ a nested IF part.
Shougata Bose says:

Is it possible to get substracted value with suffix/examination.
to be precise,
i desire to get the following,

10:00 PM-04:00 PM=06:00 hrs
later on subtraction i get 06:00, but non with hrs. I desire to become with hrs "suffix".
thank you
Shougata Bose says:

I want to do the following work with IF part,
If(A2=A-620,"Bose",""); can i do it.
here A-620 is Mr. Bose's ID number.
- How-do-you-do!
  Use quotation marks when comparison cell values to the text.
  
  If(A2="A-620","Bose","")
khoro Avhavhoni Tshivhula says:

please aid

if a2 is >1 bank check if the date on b2 is > appointment on a1 and return yep if all statements are true no if fake
Thir says:

How practice I exercise something like an IF with a random test and 1 of the outputs is the same random similar this:

=IF(random_number>0.5,same_random_number,0)

I hope you lot know what I'm saying cause I don't.
- Thir says:
  
  Oh, expect I figured it out myself. Never mind.
  
  Thanks anyhow!
- How-do-you-do!
  Please bank check out this article to larn how to сreate random numbers with specified decimal places.
  I hope it'll be helpful.
Jay says:

How-do-you-do,

I want to make a formula in which the value of A1 is less than or equal to 10, A2 volition show "1" but if A1 is greater than 10 say 12 for example the excess ii will multiplied to 0.5 then A2 volition exist 10+(Ten*0.five)/A1

=IF(A1>=10,"x+0.5X"&FIXED(A1-10,0),ane)
- Howdy!
  Please check the formula below, information technology should work for you:
  
  =IF(A1>10,ten+Stock-still(A1-10,0)*0.5,1)
Natnael says:

Hullo,
i need a formula to do the following calculations:
IF A2 and A3 are blank and then to render bare only if there are values greater than zero to multiply A2*A3
- Hi!
  Please re-bank check the article in a higher place since it covers your case.
Bearding says:

(auto result req)
Packing sr no no of box
D1 to D2 ii
D3 to d5 3
D5 to D9 4
as per in a higher place case i want auto sum in excel for packing sr no
Lloyd says:

I need help with the below given formula. It has two sells to chose from. Cell AE5 is a date. The output required is taht if the date in AE% is lower than today and so output cell should read "Notation Due", Withal if the other cell that is AF5 is bare then output required is "Not Received" and if it is not blance the the output required is "Received"

If the engagement criteia is satisfied then i exercise not desire further output of "Not Received" or "Received"

=IF(AND(AE5<TODAY(),"Non Due"),IF(AND(ISBLANK(AF5)),"Not Received","Received"))

Requesting to delight help.
- Hello!
  If my understanding is correct, you tin can use this formula:
  
  =IF(AE5<TODAY(),"Non Due",IF(ISBLANK(AF5),"Non Received","Received"))
  - Lloyd says:
    
    Dear Mr. Trifuntov,
    Give thanks you for your revert. Yous accept made it amazingly elementary. Sincerely capeesh. It fits well and resolves my query with exception to scenerio under option four. The final formula i am using is:
    =IF(AE5>TODAY(),"Non Due",IF(ISBLANK(AF5),"Not Received","Received"))
    
    In the outputs beneath Amount is AD5 , Date due on is AE5, Received on is AF5 and output cell is the column marked Status that is AG5. Under pick 4 nosotros receive the amount earlier the due date. Nosotros wanted to give a preference that if the amount is received before due engagement then output should show "Received" instead of showing "Non Due". Would information technology exist possible to incorporate such preference in the formula.
    
    Output one
    Amount Date Status
    Due On Received On
    200,000 27-10-21 Not Received
    
    Output 2
    Amount Engagement Status
    Due On Received On
    200,000 27-10-21 28-10-21 Received
    
    Output 3
    Corporeality Appointment Condition
    Due On Received On
    200,000 thirty-11-21 Not Due
    
    Output 4
    Amount Date Status
    Due On Received On
    200,000 thirty-11-21 29-10-21 Not Due
Mathew says:

Hi, i am trying to create an IF function that when you have typed "DONE", the exact engagement when the word was typed will exist reflected on another cell. Whilst when "ONGOING" is typed, the engagement shown will be the engagement today, and will however keep just until the word Washed is typed. Thanks for the help.
- Howdy!
  Excel functions tin can simply change values in the cell with which they are written.
Chris Wong says:

Hi,

URGENT

I am in urgent need to a formula to assistance me update a current file with new COGS and RRP pricing.

Simply not all articles under a sure category demand to exist updated. So if I filtered original file to a specific category and did a VLOOKUP, will any data on not filtered rows alter besides if row numbers are not in running social club and skips rows?

Basically, I only want to update some articles with new data and retain existing data for those manufactures not on new data file.

Thanking you.

Chris
Moamen says:

what if I want to apply VLOOKUP but the value is a specific word in the cell
I hateful the formula take to find text start and and so arrive value
- Hi!
  Your consequence is not clear. Explain in more item.
Robert says:

Hi, I am tracking 'aging overdue invoices', and I am creating an IF argument formula where information technology finds the total per days outstanding. My database output provides the days outstanding and many ROWS I go the text "Aught". All overdue days list correctly on 2d column with current formula. How can I insert the TEXT "Zippo" on "column B" Aging Saucepan when "Column A" reads NULL?

Here is my electric current formula inserted on "Column "Crumbling Bucket" ROW "B2":

=IF(A2>ninety,"91-120 Days Past Due ",IF(A2>60,"61-90 Days By Due",IF(A2>15,"16-30 Days Past due",IF(A2>-0.1,"0-15 Days By Due","0 Current"))))

My current data output:

Column A

Days_Overdue
NULL
NULL
280
19

Column B

Aging Bucket
181-365+ Days Past Due
181-365+ Days Past Due
181-365+ Days Past Due
0-xxx Current
- Hi!
  A Zilch fault occurs when the ranges y'all specify do not overlap. You can supplant the error with any value, including the text "Naught", using the IFERROR office.
MUBANIBASHA says:

Hullo

Please could someone aid me I am trying to create the following

EX:
If M2 is less or equal to 0.01-0.99 return the text in prison cell N2 "0"

EX:

iF M2 is less 12 return the N2 "12" and higher up 12, 13 14 is render N2 12,13,14.
steven says:

howdy, i'd similar to enquire more than almost this

How should I type if the value is between 1-200, it types forty%;
201-300 type xv%;
301-600 type ten%;
601-900 type 5%

Thanks
Alison says:

Hi,
I'g trying to detect the right office to give me the following.
For any price that is a full number, give me back 'reg cost', ex. 5.00
for any price ending with .98, give me dorsum 'mkdn cost', ex. 4.98.

Can anyone help?
Thanks,
Alison
- Hello!
  I don't understand what you lot desire to practice. Requite an instance of source information and desired result.
Bradley Rowe says:

Hello,

I'm using an IF role so that if the ranking in table A is either 9, ten or 11, we shall output the performance from another corresponding, yet separate tabular array of data and go out blank if otherwise.

The formula looks like:
=IF(P166=9,AP166,"")&IF(P166=ten,AP166,"")&IF(P166=xi,AP166,"")

This has worked to the point where the correct corresponding performance information has been outputted, yet, these are in decimal format and it volition non allow me to alter these to a percentage format (despite assuasive me to select the 'percentage option', cipher changes). Furthermore, I cannot alter the number of decimal points that the newly outputted data is displayed to.

Every bit the data is essentially the same, I thought this might non be likewise big of an consequence. Nevertheless, when I get to find the average of the iii outputted performances, I go the fault message:
#DIV/0!
Upon further digging, I institute that when I go to simply sum up the three outputs, It gives me nada (when this shouldn't be the example).

It's almost as if the IF function output isn't beingness recognised by excel despite being visible (and right) on my screen.

Any help is greatly appreciated, cheers!
Natalie B says:

Hi, I'm trying to utilise an IF part with an email address.

Example: =If(J3=123,name@domain.com,IF(j3=4567,anothername@domain.com,0))

I've tried using " " around the email addresses, but zippo works.

Thanks,
- Hello!
  Always use quotation marks for text expressions. I don't know what kind of result you wanted to get. If you wanted to get the email address equally a hyperlink, then utilize the HYPERLINK part.
Mario says:

How-do-you-do,

I am unsure if this is possible though whatsoever assist is appreciated.

I take prison cell B2 with the value four (YVL)

I am trying to write a formula that says IF(B2<x&" (YVL)","over","shift").

Is this possible?

Thank you lot in advance
- Mario says:
  
  Hello proceeds,
  
  Delight ignore the above question. I tried a IF(COUNT(Find formula and it seems to accept worked.
  
  cheers,
- Hi!
  Use IF AND argument to check ii conditions:
  
  =IF(AND(--LEFT(A1,SEARCH(" ",A1,i))<ten,MID(A1,SEARCH("(",A1)+1,iii)="YVL"),"over","shift")
Loraine says:

Hi, cheers for share all of functions above. This helped me a lot, ^^.
Dusan says:

Hi guys, i need help with something. I checked this text and deceit find out if something like i need can be washed in excel or not...

For case, i have 12 values in dropdown carte in a cell (data validation) and i would like if i can gear up something that when i modify value from dropdown carte du jour, excel can input predefined text (2 options just) in predetermined field.

For instance, if i select P-3340 from dropdown menu, i would like for excel to modify cell below into From well.

Tin something similar that be done? I really dont demand eny calculations, just that when i select something from dropdown menu, information technology changes next jail cell or two. I practise a lot of repetitive reports and this would save a ton of time.
- Hi!
  The drop-downwardly list writes the selected value from this list to the prison cell.
  Y'all cannot solve your problem using standard Excel tools.
Ana says:

I'm trying to writ and IF statement that compares 2 cells with dates in them.

IF( F4= A$one,B$1,M3)
A1=a date pulled in via a VLOOKUP formula and is dynamic
F4=09/15/2021
F5=F4+ane
F6=F5+1
ect.

I tried the following:

=IF(DATEVALUE(F4)=DATEVALUE(A$i),B$one,M3)

But I got an Fault, any suggestions?
- Ana says:
  
  As well tried =IF(DATEVALUE(nine/xv/2021)=DATEVALUE(Eastward$iv),K$4,L6)
- How-do-you-do!
  The DATEVALUE office only works with dates that are written equally text. You practice have not a text in the F4 cell, simply the date.
  Try formula
  
  =IF(F4=A$1,B$ane,M3)
Nia says:

Hi How virtually if example
if 150.00 if the naught cents information technology will choose the cell d2
if 150.50 so will choose the d4.

How will i do that?

Cheers
- Hi!
  To get the fractional part of a number, use the INT part:
  
  =A1-INT(A1)
  
  Use this formula in an IF function equally described earlier in this commodity.
Sherry says:

Hello, how exercise you program a cell to fill up itself with "1" based on the given date range? I have all dates in one row and in the column I have employee names.
- Hi!
  I am not sure I fully understand what you mean. Give an example of your information and an example of the result y'all want to go.
Sasha says:

how-do-you-do,

the values in my prison cell are "<90", the if formal hasn't been picking up on this and is returning the second condition for all cases
Is there anyway to fix this?
- Hi!
  Explain your problem in detail.
Balasaravanan Palanirajh says:

Thank you very much
I've learnt a lot more hither than in class
I was able to find what was needed so and at that place
Thank you once again
Good chore, y'all all
Matthew Ammerman says:

Hi! I could utilise some aid if anyone is bachelor.

I have ii sheets that contain the same cavalcade called "Content Title".

Sheet ii has an additional column with data in it chosen "Full Unique Users". I want to bring over the data from Canvas 2 column "Full Unique Users" to Sheet 1 if I tin can discover the same Content Title in Sheet 1.

For instance, If Content Title in Canvass 1 is equal in Sheet 2, pull the data from the "Full Unique Users" column in Canvass ii into Canvas one.

Any help is appreciated. Thank you!
Mr David Richman says:

I have 2 columns of numbers , cOL C&D . I need Col A to correspond a letter based on these criteria.
If C is greater than D and then show text H else show A

I have =IF($C$3>$D$iii,"H","A") this works OK but if the numbers match I need to bear witness text D. How can I practise this please..
- Hello!
  You tin use this formula:
  
  =IF(C3>D3,"H",IF(C3=D3,"D","A"))
  
  Y'all can acquire more about nested IF statements in Excel in this commodity on our blog.
  - Mr David Richman says:
    
    Thank you so much for your FAST solution - information technology works great.. in fact y'all are 'Alexander the corking'.
Annette says:

Hullo,
I'g trying to use formula in a budget where
C3 D3 ($eg) E3(monthly)
yearly $95000 = D3/12
monthly $500 = D3*ane
weekly $50 = D3*4

Please assist with e3 cell formulas

Regards
Annette
- Hullo!
  If I understand your task correctly, the following formula should work for you:
  
  =IF(C3="yearly",D3/12,IF(C3="monthly",D3,IF(C3="weekly",D3*four,"")))
Bird says:

I want to write a statement in sail named Master, that reads a cell in sheet named 2021 and if information technology says N, come back with NO. If it is blank, I want it to come back with a blank. If information technology is anything else, I want it to give me the value in another cell in sheet 2021. How exercise I exercise this? I have tried a bunch of different IF functions and everything comes dorsum with an mistake.
- Hello!
  Employ a formula similar this:
  
  =IF('2021'!B1="N","No",IF('2021'!B1="","",'2021'!B2))
  
  Y'all tin learn more well-nigh nested IF in this article.
James Veleno says:

To everyone, I need help.
Column A1: John Doe
Column A2: Jim Doe
Column A3: James Doe
...

So, columns B should be:
Column B1: 12345
Column B2: 23456
Column B3: 34567

John is 12345, Jim is 23456, James is 34567.
How to make formula that puts their numbers when I put their names?
Richar Wooley says:

Working on setting upwardly a asset inventory canvas using existing bar codes,

I tin get the Barcode to scan insert Barcode number and insert scan date. But I too need it to search the spreadsheet for a matching barcode, and update the scanned date with the current date.

Present lawmaking:
Individual Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim 10 As Integer
For 10 = 2 To 1000
If Cells(x, one).Value "" And Cells(x, 2).Value = "" And so
Cells(x, two).Value = Date & " " & Time

Cells(x, two).NumberFormat = "m/d/yyyy h:mm AM/PM"

End If

Next

Range("B:B").EntireColumn.AutoFit
Stop Sub

Would like to accept it to where I scan in one Cell and have it search for exsisting data lucifer or append @ the cease of the rows.
Danielle says:

=(IF(N191.four,N191.vii,N192.four,"NORA"))))
Hello!
I would like to write a formula maxim:

if N191.4 and N191.7 and N192.iv write NORA
Danielle says:

=IF(N191.4,N19<1.7, "PA"))
How-do-you-do, This formula enters False or True instead of PA when the value is between 1.4 and 1.vii.
Thank you lot for your assist
Donnette Stanley says:

I have spent hours and cannot effigy this out. I have a spreadsheet with contract numbers and textile numbers, a second tab has the same information contract numbers and material numbers but it includes a line for each shipment. I am trying to come up with a formula that counts the number of shipments, And then anything greater than 0 that matches the contract number and the material number count as 1. I cannot figure it out: =COUNifs('Aug 2021'!Eastward:Eastward,">0",'Aug 2021'!J:J,D2,'Aug 2021'!I:I,E2) This is the closest I have gotten and it comes up with the #name?
- Hullo!
  If you write the name of the COUNTIFS office correctly, so I think there will exist no mistake.
Mike Excell says:

I don't sympathise why my if statement does non work. I am searching for age based on year in 2 digit format. 98, 02, 13 ect. The year for the exercise is 2014. The formula I wrote follows:

=IF(F6<14, 14-F6, 114-F6)

The results all come up back fourteen-F6 no affair if the value is above or beneath 14. but if information technology is in a higher place 14 shouldn't the role follow the false upshot part of 114-F6?

Does a have to exist equated to zero specifically or something. I finally got the function to work with =IF(F6-14>0, 100-F6+fourteen, fourteen-F6) only that seems similar a lot of extra steps compared to my first equation.
- Hello!
  I'm lamentable but your task is not entirely clear to me.
  What are the values recorded in F6? Are these values written equally number, date, or text? The value 02 is text and cannot be compared to a number. Specify your question.
Laurent says:

Hello, I'k wondering if you can help me? Looking to create a formula to simply place currency 'EUR' or 'USD' in source column, to and then compute exchange charge per unit for that currency in next column. I have been trying to use the 'IF' part, simply it doesn't work. For example:

Column A: 'EUR' or 'USD'
Column B: =IF(A1=EUR,"iv.50","3.67")

However this is giving me #NAME? fault.

Was wondering if yous had any suggestions?
Thanks!
- Hullo!
  Please endeavor the following formula:
  
  =IF(A1="EUR",4.50,3.67)
LS says:

I have i column where hours will be put. If one 24-hour interval has zero hours, I desire another column on aforementioned day to put DYO, and in a third column for it to put twenty-four hours off, and all other columns to remain blank. This will all remain on one engagement or line. I would like information technology all done based on that 1 cavalcade having zero. Any ideas on formula?
Toba Fawekun says:

How-do-you-do, I have this formula that works individually but volition like to have it as a unmarried formula.
=IF(L6="SUPPRESSED", (EDATE(N6,11).
=IF(L6="UNSUPPRESSED", (EDATE(N6,3).
In my table, the 50 cavalcade returned "Suppressed" if the value connected to its formula is k. So I desire a single formula the will return (EDATE(N6,11) and (EDATE(N6,three) if the Fifty column returned "Suppressed" or "Unsuppressed".
AJ says:

Howdy anybody,

Please could someone aid me I am trying to create the following

If M2 is less or equal to 0-0.99 return the text in prison cell N2 "0"
If M2 is less or equal to ane.00-1.99 return the text in cell N2 "1"
If M2 is less or equal to two.00-ii.99 render the text in cell N2 "two"
If M2 is less or equal to 3.00-3.99 return the text in cell N2 "three"
If M2 is less or equal to 4.00-4.99 render the text in cell N2 "4"
If M2 is less or equal to 5.00-5.99 return the text in cell N2 "5"
If M2 is less or equal to 6.00-six.99 return the text in cell N2 "6"
If M2 is less or equal to vii.00-seven.99 return the text in cell N2 "7"
If M2 is less or equal to viii.00-8.99 return the text in jail cell N2 "8"
If M2 is less or equal to 9.00-9.49 return the text in cell N2 "9"
If M2 is less or equal to 9.50-nine.99 render the text in cell N2 "10B"
If M2 is equal to 10.00 render the text in jail cell N2 "10A"

Any assistance would be hugely appreciated.
- Hello!
  The formula below will do the play a trick on for you:
  
  =IF(INT(M2)<9,INT(M2),IF(Circular(M2,2)<9.v,nine,IF(ROUND(M2,2)<x,"10B","10A")))
  
  You can learn more most rounding in Excel in this commodity on our blog.
  - AJ says:
    
    Cheers Alex!
Nixon Omblero Canedo says:

Trans. Date Type of Customers Due Date

06/ten/21 Regular 06/25/21
06/ten/21 Assignment 06/17/21

Notation:

i) What is the formula to add 15 days from the date of transaction
Evanlog says:

Skilful
Allison says:

Howdy. I am trying to create a formula that compares a single cell to an entire column(unlimited number) of data. Basically I have a tracking # in a cell and need to compare that to a column consisting of tracking #'s that take been shipped(I volition be continuously adding to this cavalcade). I want to create a cavalcade that lets me know if that tracking # in a cell has been shipped.
So I was tried using formula:
=if(C9=I:I,"Shipped","Freezer")

But it doesn't not piece of work. even though that jail cell(C9) matches a number in I:I, information technology will not display shipped and only displays freezer instead.
- Hullo!
  The IF function does not work with ranges. Please use the following formula
  
  =IF(ISNUMBER(Match(C9,I:I,0)),"Shipped","Freezer")
  
  You tin larn more about Friction match role in Excel in this article on our blog.