I Have a Multi select When Want Select Again First Data Is Cleaned in the Matlab
three,805 comments to "Excel IF statement with multiple AND/OR conditions, nested IF formulas, and more than"
-
Anjali D says:
Could you assistance me to write a formula for IF B2 is Yeah, then it should consider the data present in A2,if B2 is No, and so it should be blank
-
Sabrina says:
How-do-you-do,
I'one thousand looking at trying go a yes/ no answer for a column that has "yes" or "no" data entered.
If the column is all "yes" the statement is true and the issue should exist "yes". Is in that location a mode to do this?
Due east.k.
A1 Yes
A2 Yes
A3 Yes
A4 Formula gives the answer "Yes"
Notwithstanding, if A2 had "No", the formula in A4 would requite the answer as "No"
Whatever help would be appreciated as I have been researching for a few months on and off at present.
-
Deb says:
I demand a formula that will do the post-obit:
=IF(F2*60%)/32)2, I desire three for my answer, If >i and < 3 I need 2 as my answer. thanks kindly
-
It dropped something from my question:
=IF(F2*60%)/32) >2 I want 3, <two I desire 1 and one I want two.
-
-
Roy says:
the "," does not work! it has to be ";" to work
-
How-do-you-do! Is information technology possible that I can have two values if my logical test is true?
Example:
If(A1>0, B1-A1 and at the same fourth dimension C1-A1, "")I hope I explained information technology well. Cheers.
-
Howdy!
How practise you write these two values into one cell?-
I write information technology like this =IF(A1>0, OR(B1-A1, C1-A1),"")
-
-
-
Hi,
Required to identify credit / debit ( contain with "-" later number that is credit, otherwise debitmy information as beneath
84.03
0.05
0.58-
131,429.79
209,489.24
239,999.ninety
145,599.21
0.44
0.43
170,989.seventy
4,666.29-
0.98-
0.39 -
Shaun says:
Hi
A1=100
A2=fifty
=sum(A2-A1) WILL = -l
How practice I make it bear witness 0 -
Casey Perry says:
Hi, can you lot please aid me write an IF formula/statement that alerts users of a chart that the total nett profit after taxation is less than x% of the full sales?
-
If I calculate 12 rolls of different yardings in 1 prison cell and i want to know the quantity of rolls in different cells. Then what formula should i use?
-
Arya says:
If my amount of 20001 more is v%.
Rate monthly GP
3% 20000
v% 20,001 - xl,000Margin* Cons Margin* %
3,131.twenty 3,131.20 iii%=IF(Cons Margin<20000,3%,5%)
1,844.40 4,975.60 3%
2,720.00 vii,695.sixty 3%
2,604.00 10,299.sixty 3%
2,620.fourscore 12,920.40 three%
3,633.00 16,553.twoscore 3%
2,856.00 19,409.40 3%
2,155.33 21,564.73 5%
1,890.00 23,454.73 v%
2,204.00 25,658.73 5%
3,192.00 28,850.73 5%
1,920.00 xxx,770.73 v%
1,817.lx 32,588.33 5%When 3% to 5% so 3% on 20001 but what happen hither it is calculate 2,155.33 (21,564.73) on five% this is not correct.
So Can you please help me it how to calculate my Verbal 20001 on 5%?
I know information technology's really hard to explain but please let me if y'all have any suggestions. -
annas says:
How-do-you-do, i need formula to calculate cost from 1 sites to another with many choice, for example my skillful from city a to city b cost near $4 per quintal, from city a to c $5 per quintal, from urban center d to b is $7 per quintal. only 2 destination bespeak but many source betoken with every point is dissimilar cost. thank you
-
LG says:
Hi, I'm looking for some help to automate an NBA bracket pool that I am currently running for my function.
I am application 1 point for having predicted the correct serial score (i.east. 4-0, 4-1, etc.). I take a single cell for each teams score (i.e. Team A's score will go in C5 and Team B'due south score will go in C9).I'chiliad hoping there's a formula that can award one point for having corrected the correct score. I currently accept a "principal bracket" where I am entering the series scores every bit the playoffs keep. I've tried using a formula similar =(IF(player1!C5='Puddle - Primary'!E5,1,0)) which volition give me a point if right, but this does not necessarily show whether player 1 guessed the correct serial score. Then, I need to somehow meet both conditions (or have both scores be right) in society to award a point.
Any ideas?
Thanks in advance!
LG
-
*ane signal for having PREDICTED the right score
-
I failed to mention that these formulas are on a "standings" sheet which I'yard hoping volition update automatically as I enter the series scores in the "puddle - master" sheet.
-
-
-
Mufty says:
Hullo
I take a question to solve my case..
I accept a table:
G1 to L1 : 1 2 3 1 2 iii
G2 to L2 : iv/26 4/26 four/26 iv/27 4/27 iv/27With condition :
B3 : 4/26
C3 : 3
D3 : iv/27
E3 : 3Im trying to brand a Grant Nautical chart, i already get in if the condtion just the date. But im not yet solve it with additional condition. Please help :)
-
Christina says:
I need help with creating a formula in excel
IF A5=5, then 0 points is assigned
IF A5=four, so i bespeak is assigned
IF A5=3, so 2 points is assigned
IF A5=2, so three points is assigned
IF A5=i, then 4 points id assigned
IF A5=0, then 5 points is assigned-
Gaurv says:
Just us Nested - If(Every bit=5,"0",If(Every bit=iv,"1",If(As=three,"two",If(AS=ii,"3",If(AS=1,"4",If(AS=0,"5"," "))))))
-
-
Hey please help me with the the formula for taking R12 from every R100 due .I have tried this only I can't go the correct reply when scrolling down ,=if(d6>=A4,B2,0)
-
G Prameela says:
I have a question,
If the opening size is >0.5= 3 then half opening size deduction
If the opening size is >three then full opening size deduction
Ex Door = two.0 x 2.1m = 4.ii Sqm is the opening size, and then criteria two
If Door = 1.2 x ii.i = 2.52, then one-half of the opening size (2.52/2) criteria ane -
northward/a says:
Is there an excel formula where I want that if the birthdate (Cavalcade C) is equal to 12 and is elementary level (Column Grand) and so information technology volition returns to the age (Cavalcade Due east)otherwise returns to "Underage"(Column Eastward).
-
Hi I demand help with a nested if argument, I want to calculate a specific pct co-ordinate to an alphabetical code, all entries with codes (column F) R,P,B,West need to depreciate past 5% per twelvemonth (column H) if the code is anything else the percentage is set at 50%
This is what I have and so far:
=IF(or(F10="r",f10="p",f10="b",f10="W"),and(f10=n),100%-(H10*5)/100),"50%")
-
Ken Major says:
Hullo,
I'chiliad trying to work out a formula which deducts travel time from appt time. Column 'P' is actual Appt elapsing, Column U is overall Appt duration (inc travel) I have the following formula which deducts actual appt time from overall appt time just wanted to include an IF statement proverb take column 'U' if information technology = 00:00 (no travel time) so currently have the post-obit: =IF(U135="00:00",U135,IF(U136<P136,P136-U136,U136-P136))
Yet this isn't working equally still calculates regardless of column 'U' existence 00:00, any idea what I'yard doing wrong?
-
Hullo,
I am trying to use an "if and" statement with 3 conditions at the end of a very long argument.
It is iii IF statements, 1 IF AND statement, and ane IF AND AND statement. The formula works up to the iii IF statements + 1 IF AND statement, only does not work in one case I add the IF AND AND argument. I have copied below what I have so far, can someone please assist?
IF(V2="*",S2,IF(S2="",T2,IF(S2="*",S2,IF(AND(S2="",T2="<"),"T2","U2",IF(AND(AND(S2="",T2=""),U2,V2))))))
Above is translated to if V2="*", and so wait at S2. If S2 is bare, so look at T2. If S2="*", then use S2. If S2 is blank and T2 = "<", and so look at T2, if non then wait at U2. If S2 is blank, and T2 = "", and then look at U2 if not and so look at V2.
-
Hemanth Kumar Vyas says:
Hi,
I require formula for a confiriton where, "If we input appointment in one cel, then a specific corporeality should popup in the destination cell"
Case: if a prison cell A15 has date 23/04/2022, and so cell G15 should popup with the corporeality fifty.
volition this be possible?
-
Wiktor says:
Dear Sir,
I noticed yous are helping a lot of people here and i would similar to ask if y'all could guide me in the right management in excel. I am trying to create a worksheet with available lens (of all sorts) for our lab. And separate worksheets with lenses grouped for uses (contact lenses/ lenses by brands and stuff like that). My idea was for the lens name with its ID from the other worksheets to be copied into the availability worksheet (similar this ='Contact Lenses'!D8). But when there is a date of taking the lens in the availability worksheet the worksheet that regards that specific lens (like 'Contact Lenses') volition have in the relevant cell a value of Yep (for taken) and a No value for when there is a date of return in a separate column in the 'availability' worksheet. Even so The problem i am struggling with is that the aforementioned lens may occur several times in the same availability worksheet - making If statements kind of ridiculous.
Things like started coming out as such - which evidently won't work
'IF(OR(AND('Availability' $C10:C100 ISTEXT = "CL1.75 #A" , 'Availability' $F10:F100 ISBLANK), AND('Availability' FC10:F100 ISTEXT = "CL1.75 #A", ISTEXT )), "Yeah", "No")('Availability' worksheet) - Cells[Lens ID, appointment of taking particular, name of person who took it, date of returning item]
Example 'Lens' worksheet - Cells [Lens ID, Specification, Available?]
I hope i explained it well enough. Do you have an idea on how to proceed with such a task?
Regards
Wiktor -
Mike says:
I am trying to go my IF formula to work with multiple conditions. Here are the conditions:
1. Jail cell C4 must contain a sure term, let'southward phone call it "apple".
2. Cell M4 must incorporate a numerical value.
If both conditions are met, I would like to decrease the value in cell M4 from the value in cell D4.
If one or both of the two conditions are Not met, I would like to render the value "North/A"Thank you in advance for your help!
Mike-
Hello!
To check if a jail cell contains a number, use the ISNUMBER function. Also, use the recommendations from the article above.=IF(AND(C4="apple",ISNUMBER(M4)),D4-M4,"N/A")
This should solve your chore.
-
Thank you Alexander, this worked well. I was not employing the ISNUMBER part, simply I had the rest of the formula elements. I really appreciate the swift response.
-
-
-
Sawyer Bollitier says:
I have. project and I'thou struggling to know how to do this IF formula given what they say:
"The dataset contains ten measurements of pupil readiness for college in columns B-Thousand. The clarification of each 1 of them is available in the file."
"To analyze this data, you need to create additional columns and recode the data, making low a i, moderate, a 2, and Loftier a iii (you can employ an IF function to do this). In this format, the highest the number, the more than prepared the educatee is."the cavalcade already says moderate low and loftier what function would I do to get information technology to codify to 1,2,3, etc...
-
Francesca says:
Sorry not all the context was stated in my bulletin, The results , need to exist
Poor (345) -
How-do-you-do Alexander, I am hoping yous tin help me, its probably a simple formula, I just can't seem to become my head around.
I take a listing of scores ( results) in i column, from these scores I need to decide, poor ( 345). preferably the result being the corresponding text.Average Total Output
2.3
2.4
two.5
ii.6
2.vii
2.viii
2.8This is my formula so far: =IF(J2>=5,"tiptop",IF(J23,"skillful",IF(J2>33>0,"poor",)))) only its not giving me the event I am looking for. Help appreciated.
-
Phiwe says:
Howdy
Please assistance me with this scenario:
Jitney fare from A to B - $30 for the elderly
Autobus fare from A to B - $50 for adults
Charabanc fare from A to B - $40 for teenagers
Jitney fare from A to B - $30 for kidsBus fare from B to C - $35 for the elderly
Bus fare from B to C - $55 for adults
Jitney fare from B to C - $45 for teenagers
Bus fare from B to C - $35 for kidsI receive trip sheets with passengers' dates of nascence and destinations then I desire create a formular that says if a passenger is 13 years old, and travelled from B to C, they should accept paid $45
-
Jennifer says:
Good afternoon,
I need 2 different formulas for per centum increment/decrease in ane cell.
For more than clarification...I am compiling statistics. July 2020 has 0 (crime reported) and July 2021 has i (criminal offense reported).
I used this formula: =IF(ISERROR((L23-L4)/D4),0, (L23-L4)/L4) and the pct is 0%.
I need to testify the 100% increase from 2020-2021.So I used this formula : =if(iserror((L23-L4)/L4),one,(L23-L4)/L4) and the percentage inverse to 100%.
Some months take say 5 (reported crimes) in 2020 and 13 (reported crimes) in 2021. For those, the formula =IF(ISERROR((D34-D15)/D15),0, (D34-D15)/D15) works.
Is there a manner to combine both formulas for each cell in society to give me an and/or result?
Thank you kindly for your response.
-
Theodora F says:
Hello. I demand to combine 2 functions and need help please.
2 cells H177 and H65
when H77 is <=0,two i want to calculate the abs difference and if is 0.05 ok, if non Failed
=IF(AND(H177<=0,2;ABS(H177-H65) 0.ii it responds equally Failed,but how can i combine
when H77 is >0,2 ABS((H177-H65)*100/H77)<twenty);"OK";"FAILED") -
Filip says:
Howdy, I am trying to do the following:
If c2 is blue (truthful or false) then c3=c2 - eightIf c2 is another colour nothing happens
So.. is it possible to bind c3 to a c2 in that style and still be able to write any number in c3 if condition is non met?
Thanks
-
sahal says:
I take a list of prices. "X" and "Non-Ten" products (one column). I want the price separately to the "X" Column and "Non-Ten" Column from that mixed list..
-
Kerner says:
Hi,
I am trying to create a lawmaking for trading.
C3 is Australian Dollar
D3 is Euro
bull is upwardly
bear is downwardly
cons is consolidating/sidewaysThere is 8 different combinations for the respond that tin be seen in the function beneath.
=IF(AND(D3="bull";C3="bear"); "bull";"") IF(AND(D3="behave";C3="bull");"behave";"") IF(AND(D3="balderdash";C3="bull"); "cons";"") IF(AND(D3="carry";C3="behave"); "cons";"") IF(AND(D3="bull";C3="cons"); "balderdash";"") IF(AND(D3="acquit";C3="cons"); "bear";"") IF(AND(D3="cons";
-
Here is the full function
=IF(AND(D3="bull";C3="bear"); "balderdash";"") IF(AND(D3="deport";C3="bull");"bear";"") IF(AND(D3="bull";C3="bull"); "cons";"") IF(AND(D3="carry";C3="bear"); "cons";"") IF(AND(D3="bull";C3="cons"); "bull";"") IF(AND(D3="bear";C3="cons"); "bear";"") IF(AND(D3="cons";C3="bull"); "bear";"") IF(AND(D3="cons";C3="bear"); "bull";"")
-
How-do-you-do!
If I sympathize the problem correctly, yous have many combinations of atmospheric condition in two columns. I recommend writing down all possible combinations in a tabular array and using the VLOOKUP office to search for the desired option. Here is a guide with examples: How to Vlookup multiple criteria in Excel.
I hope I answered your question. If something is still unclear, please feel costless to ask.-
Thank y'all for the quick response!
I digged into VLOOKUP function and I am not 100% sure how to employ information technology in my instance. I will endeavour to further explicate my situation.
Basically I take eight possible combinations and 3 possible outcomes, but but one right reply.
Beginning word is i currency (Australian Dollar)
Second give-and-take is the other currency (Euro)
Answer is what their cross currency should exist if conditions are met (EURO / Australian Dollar)
bull + bull = cons
bear + behave = cons
bull + deport = bear
bear + bull = bull
cons + bull = bull
cons + carry = bear
bull + cons = behave
deport + cons = bullAt that place tin only be one right answer for each date.
-
-
-
Andy says:
Hi, I have two columns of data, both containing either a 0 or a 1.
I demand to be able to code the cell in another column to read the data and render a number...
i.due east : when it is 0 in both columns, to return a 0.... then one , 0 to render a 1... etc.I accept tried this;
=IF((AND(D2=0, E2=0),0), IF(AND(D2=0, E2=one), 1), IF(AND(D2=1, E2=0), 2), 3)
Any help would exist profoundly appreciated.
-
Hullo!
If I sympathise your task correctly, try the post-obit formula:=IF(AND(D2=0,E2=0),0,IF(AND(D2=0,E2=one),ane,IF(AND(D2=i,E2=0),ii,3)))
-
Give thanks you and so much for your speedy response. This resolved the issue.
So close, withal so far. Bracket, everybody's all-time friend and worst enemy.
-
-
-
Manju says:
Range Commission %
> 800 16.0%
> 600 to 400 to 299 to < 399 22.0%
< 299 23.0%I have a big ready of values I need to calculate the commission. How practise I apply the formula in excel to calculate the committee value? Please advise.
-
Francesca says:
Hi, I'm trying to create a formula to prove the following:
If residency column is "Res" and "Off" = 32068
If residency cavalcade is "Res" and "On" = 31846
If residency cavalcade is "Nonres" and "Off"= 61564
If residency column is "Nonres" and "On" = 61342Thank you!
-
How-do-you-do
I take multiple conditions to fulfill every bit described beneath, I am trying to use IF formula just it is non working. Delight suggest.If a client selects qty between 0-10 and then no discount of total price.
If a customer selects qty between 10-20 so 5% disbelieve of total price.
If a customer selects qty betwixt 20-xxx so x% discount of full cost.
If a customer selects qty >30 so 15% discount of total cost.Give thanks you
-
Yash says:
I have problem, I have to values for L21 & L23 and final outcome is CA..
CA= L23*3+L21*2 if value of L23 is greater than 0
Like - L23 = 3 L21 = 2, and so CA = 3*3+two*two=13and if L23 =0 and L21 =3, then CA=0
Pls propose farmula
-
Hello!
If I empathise your task correctly, try the post-obit formula:=IF(L23>0,L23*3+L21*2,IF(L21=iii,0,""))
You tin larn more about nested IF statements in Excel in this article on our blog.
-
I'm trying a formula where data exixts in one sail, i need answer in 1 canvass with below condition, Can you lot delight provide the formula for this
Sheet 1: Answer & Sheet two : Existed Data
I'm inputting formula in Answer sheet with below conditions
If G column Data matches with A Column Data of "Existed Data and
If J Column Data matches with B Coumn Data of "Existed Data and
If Xcolumn Data matches with C columnd Data of : "Existed Data so
answer to be announced which is in D cavalcade of Existed Information.-
-
Bhagath says:
I'm getting an mistake at terminate as The formula is missing an Opening or Closing Parenthesis.
-
Hi!
Check if you copied the formula correctly. It works without errors.-
tin can i select entire column instead of prison cell
=if(AND(Sheet1!A:A=Sheet2!A:A,Sheet1!B:B=Sheet2!B:B,Sheet1!C:C=Sheet2!C:C,=Sheet1!D:D,"")
-
-
-
-
-
-
-
Sheikh Hameed says:
In a drop downward tab there are 4 names, I want Excel to read selected name and some of the data tin can be written that person sheet in real time or command to re-create
I am totally beginner love to acquire, I appreciate you had well explained the utilise of IF AND OR
Thank you
Hameed -
Andreas says:
Hey! I want excel to perform unlike calculation depending on the outcome of a fraction, ive tried the following formula only deceit get it working, how should i put information technology instead?
=IF(SUM(I2/Q2)0.30.l.7, "R2*0.5", "R2*0.75", "R2*0.9", "R2*one.0"))
-
Marty says:
I have a trouble where scoringh is made based on split up conditions existence met and i am stumped.
Case: If name = Type one and Condition = Y, score 2, otherwise score 1.
The formula below doesn't seem to work properly.
=IF(AND(Y2="Y"),IF(AND(P2="Type 1"),2,i))
Additionally, If neither is it possible to have 0, rather than Imitation?
If anyone is able to answer this for me, i'd be extremely grateful :)
-
-
Thanks for your help, that's corking!
-
-
-
blixwahoo08 says:
hello need this lawmaking to right please assistance
i have date on M17 given and the are encode MM/DD/YYYY
i desire to auto fill up the date if 1st quarter or 2d and so on.....this is my sample lawmaking but the outcome is always 4th Quarter need help to correct it thanks
=IF(M17>=10/1/2022,"4th Quarter",IF(M17>=7/1/2022,"third Quarter",IF(M17>=4/1/2022,"second Quarter",IF(M17>=1/i/2022,"1st Quarter"))))
-
i have date on M17 given and they are encoded on this format MM/DD/YYYY dateshort
-
-
Parthiban p says:
I will utilize this ( if(vlookup(a2, sheet1! A:ap, 42,0) ="TN", A2, "") fourmal this condition only sow TN state,
Now I demand TN & KA Country which fourmal apply plz help???? -
Mahir.zicNe says:
How-do-you-do,
I am trying to brand eGFR calculator. Information technology needs to differ between men and women and different serum concentrations of creatinine (SCr). Formula reads every bit follows:
142 10 (Scr/A)^B x 0.9938^age 10 (ane.012 if female), where A and B are the following:Female person Male
SCr ≤0.7, A = 0.seven B = -0.241 SCr ≤0.ix A = 0.9 B = -0.302
SCr >0.vii A = 0.7 B = -i.2 SCr >0.9 A = 0.nine B = -1.2
So what I need is to Excel calculate/show value of B in one cell when specific conditions are met. For example patient is female person and SCr is 0,55 (it is <0,vii) B should exist B=-0,241 and etc.
Is information technology possible to exam combinations of two variables (sexual activity and SCr) to calculate three possible outcomes of B (-0,241, for women, -0,302 for men, and -1,2 in cases when SCr is greater than 0,7 for women, 0,9 for men, respectively)?Looking forward to your answer
Edit of previous annotate due to error.
-
MarcelP says:
I delight need aid doing a formula for the following, which should just be one formula :Combine these into 1 formula
if cell A is empty , it must use cell B info , if cell B is empty, it must use cell A info , If both prison cell A and B has info in it and so it must use Prison cell B info, If no info and so information technology must prove a clear prison cell and not a 0. -
Theo says:
Hi there, I am looking for a formula which will return the following result:
If text in cell A1 matches the text in prison cell range A1:A100, and so bear witness text from cell B1, assuming A1 is Proper noun and B1 is Surname, please assistance.
-
Nicky says:
Hi
=IF(OR(AND(L37="Aye"),OR(M36="Yes",N36="Aye",M37="Aye",N37="Yes")),"Yes","No")
Effectively, the formula should be saying if L37 is Yes, and M37 or N37 is Yes, then give Aye, or if L37 is No, and M36 or N36 is Yeah, and so give Yes. Everything else, give No.
the above formula is coming back every bit a Yes where it should say No.
are there any other formalas i tin apply?
-
Jane says:
I am trying to get a formula for my budget.
I need to calculate Direction fees that are calculated at 2% of revenue. There is a minimum charge of $xx,000.00 meaning that the to the lowest degree I will exist invoiced for management fees is $xx,000.00.
So my formula needs to read that if 2% of my revenue is less then $twenty 000 so the answer is $20 000. If ii% of my revenue is greater than $xx 000 and so the respond should be 2% of that effigy. -
karthik says:
Hi,
Can You help me in this beneath Case
=IF(F17=0, "F43*1", IF(F17=0.5, "F43*0.five", IF(F17=i, "F43*0")))
Here In "F43*1" - Is also the formula
Explanation,
If F17 = 0, then F43 should multiplies with 1 (F43*ane),
Similarly, Every bit follows
If F17 = 0.five, then F43 should multiplies with 0.five (F43*0.5),
If F17 = 1, then F43 should multiplies with 0 (F43*0),
*F43 is Sum of (F18:F42)
-
Hi tin you help me, the other formula is not working
=IF(G1110,G11*24.17, IF(G11>20, G11*26.39, IF(G11>30, G11*28.92, IF(G11>40, G11*32.fifteen)))))
-
Hullo!
I can't test your formula because I don't know what effect y'all desire. But your formula was written incorrectly and contained an extra bracket.=IF(G1110,G11*24.17,IF(G11 > 20,G11*26.39,IF(G11 > 30,G11*28.92,IF(G11 > twoscore,G11*32.15))))
-
here's the water charge per unit per cu.m.
0-10 CU.M = 224.02 (MINIMUM RATE)
11-twenty CU.One thousand = 24.17 PER CU.M
21-30 CU.M = 26.39 PER CU.M
31-40 CU.Chiliad = 28.92 PER CU.One thousand
OVER 40 CU.M = 32.15 PER CU.GrandWHAT FORMULA SHOULD I USE, THAT ALL THE Weather condition Volition WORK.
Thanks IN Accelerate
-
-
-
TASSOS says:
Howdy, if in one cell (C25) I have 3 possible options (1, Ten, 2) then how can I get the values if i=3, if Ten=1 and if 2=0? I typed the following formula, only with no luck
=IF(C25=1;iii,IF(C25=x;ane,IF(C25=2;0)))
-
Randy Milligan says:
Hither is my issue:
=IF(AND(I4="Residential",J4="Self-Generated"),8%,6%)
which I can get to calculate perfectly but I need it to have four conditions
=IF(AND(I4="Residential",J4="Self-Generated"),8%,6%, AND (I4="Commercial",J4="Self-Generated"),10%,8%)
which I can not get to work.If Residential & Cocky-Generated 8%
If Residential & Visitor Generated half-dozen%
If Commercial & Self-Generated x%
If Commerical & Company Generated 8%Whatsoever help would be appreciated.
-
Ken Smith says:
I take the post-obit COUNTIFS formula:
=COUNTIFS($D$2:$D$494,A15,$C$2:$C$494,"A1",$N$two:$N$494,"<=15%")
which works fine. However when I try to replace "15%" with a reference to a standalone cell containing a drop down with varying percentages, the formula returns an reply of "0".
I have played with the formula for a few days and have to admit I am stumped. There is probably a simple solution only it escapes me.
Any help would be greatly appreciated.
-
Karabo says:
How-do-you-do
I am trying to create an IF function where the following is applicable:
Jail cell C4 has 3 options, "Yes", "N/A" and "No"
Cell C5 has iii options, "Yes", "Due north/A" and "No"
Cell C6 has three options, "Yeah", "Northward/A" and "No"Cell C7 contains the IF argument whereby if Cell C4 is Aye or Northward/A, Cell C5 is Yeah or North/A and Prison cell C6 is Aye or N/A the result should be "Positive". Any "No" in Cell C4, C5 and C6 should be "Negative"
-
Hello!
If I empathize your task correctly, the post-obit formula should piece of work for you:=IF(OR(C4="No", C5="No", C6="No"),"Negative","Positive")
-
Jen says:
I accept a like question to the original and I have the post-obit formula in my spreadsheet -
=IF(OR(H10="n",H11="n",H12="n"),"northward", "y")
My question is - how can I brand the formula so that when all 3 cells are blank (oasis't been tested even so) that the cell with the formula is blank? As the formula is now, that cell has a value of "y" and I oasis't scored/populated the other cells even so.
If I take out the "y" and just leave "" - I won't go a return of "y" when all 3 cells are "y" - it will but be bare.
-
How-do-you-do!
Use nested IF office:=IF(H10&H11&H12<>"",IF(OR(H10="n",H11="n",H12="due north"),"n", "y"),"")
Hope this is what you need.
-
Hullo - Thank you for answering my question so quickly. I believe I figured out a solution that took care of everything that I needed in the formula, (non but fiuring out how to leave the fomula jail cell blank - equally I originally asked for your help with).
I used -
=IF(OR(H10:H13="n"),"n",IF(AND(H10:H13="x"),"x",IF(OR(H10:H13="y","x"),"y","")))That way my formula cell will be able to populate for any of the iii possible answers - y, n and 10 (northward/a) and remain blank until the other cells are populate.
Thank you again, I really appreciate information technology! :)
-
-
-
-
-
Ram says:
After IF, I need to apply multiple AND and OR atmospheric condition and requite multiple values for true and fake appropriately, how practise I do that
-
Lisa says:
Column A has a number and I need column B to be equal to cavalcade A, unless it'due south it less than 2 I want it to be equal to 2.
-
Robbie Timmons says:
I am wracking my brain trying to sort my conundrum.
I take iii values Weekly(C5), four weekly(D5) and Monthly(E5) (which can all be inputted manually)
I am trying to write the correct IF statement that allows me to create a yearly effigy from only 1 of these values.
eastward.g. if a user enters a figure in C5 the output would be C5*12, if users enter a figure D5 then the output would be D5*13 and finally, if the user enters a figure E5 then the output is E5*12.
My trouble is that I am simply looking to output one of these figures to F5 as a yearly.
I would appreciate some advice every bit I have looked at nested IFs and tried to use the conditions around C5=0, c5>=0. I accept figured this out for using only 2 potential values but when I add in the 3rd I can't seem to figure out how to include/combine the other cells' values e.1000. E=0, E5>=0 to give me the selection of only one of the calculations working to give me a yearly.
would appreciate whatsoever advice effectually this. TIA
-
Natalia says:
HI,
how can I combine the following:
=IF((L2-M2)0,(L2-M2),0)
Thank you for help.
-
Diaa says:
Very useful article, It helped me a lot.
Thank you!! -
Kishore Loyal says:
=IF(A3=ane,"A",IF(A3=2,"B",IF(A3=iii,"C",IF(A3=4,"D",IF(A3=v,"East",IF(A3=6,"F",IF(A3=7,"One thousand",IF(A3=8,"H",IF(A3=9,"I",IF(A3=0,"X"))))))))))
This one= A 2= B i need to an formula to comnine if 1234 information technology should be abcd if it is 4321 information technology should exist dcba could you please help me with this
-
Adnan Alshakhatreh says:
Could you delight aid me to make a formula that produces a list of each form and the minimum mark in that class in a sail that accept all classes mixed together
Like if I have all marks of 6A and 6B and 6C and I want a table with one cavalcade for class and one for minimum marking in that class -
I am attempting to combine these two IF commands into one.
=IF(O2>=0.ii,"",C2)
=IF(C2="A1","A",IF(C2="A2","AA",IF(C2="A3","AAA")))
I have tried combining them with AND, only without success. I am stumped!
Any help would be profoundly appreciated.
-
Hello!
I'm sorry but your description doesn't give me a complete understanding of your task. Correct me if I'm wrong, but I believe the formula below will help:=IF(O2>=0.2,"",IF(C2="A1","A",IF(C2="A2","AA",IF(C2="A3","AAA"))))
-
Many thanks. That worked. I now see where I was in error, which was including "C2" in the outset IF control.
-
-
-
Sawan says:
Delight Help with below formula, How to utilize both formula into single statement
we have two status
=IF(AND(A1>0,B1="MIS"),"40","twenty")
=IF(AND(A1>=0,B1="NRML"),"50","100")
-
Blessed Marufu says:
Proficient day
im trying to seperate this listing using if formula
1968
19230
2068
20230
2168
4968
63230
6568
66230
68230
6968
101230
102230
10468
and i have tried to utilize this formula =IF(P6=LEN(4),Correct(P6,2),Correct(P6,four))
i want it to wait like this
xix 68
19 230
how all-time tin can i solve this -
Freddy says:
Hi,
Having problem with this..
=IF(OR(AND(H8=0,F8=100%,K3="FINALED"),AND(H8=0,F8=100%,K3="N/A"),"set up to pay","not ready to pay")
I'm looking for the same statements to come up whether or non k3="FINALED" OR "N/A".
How tin can I make that happen?
-
Hi!
I don't really empathise what result you want to get, but endeavour this formula:=IF(OR(AND(H8=0,F8=100%,K3="FINALED"), AND(H8=0,F8=100%,K3="N/A")), "fix to pay","not gear up to pay")
If this is not what y'all wanted, please draw the trouble in more detail.
-
Alexander,
The upshot I need is either "not ready to pay" or "gear up to pay".
If all three logical expressions are not met, my result should be "not prepare to pay". If they are all met, and so I need the contrary. My event was getting to the same two conclusions with the exception of k3="n/a" or "finaled".
The formula y'all sent did it! Thanks
-
-
-
AAMIR says:
Hi there are two formulas in the sheet and want to brand information technology single.
=IF((A10),"Under Process","0")
I tried below formula only it's not worked.
=IF(OR(A1>0,"Nether Procedure"),IF(B1<C1,"Claim","Not Claim"),0)Thanks
-
Hi!
Write what is the second formula. Both of these formulas must refer to the aforementioned cells. Otherwise, their association does not brand sense.-
Yeah there are 2 columns Column A and Column B.
For column A formula is;
"=IF((A10),"Recd","0")"I want to merge the formula and rail the value at single cell.
please advise if in that location is whatsoever other formula bring the result.
-
For Column B formula is;
"=IF((L10>0),"Recd","0")"
-
-
-
-
Japie says:
Hullo there, I am trying to match criteria betwixt 2 columns. In the event that they do match, I want their number values in a third column to be summed for the specific rows but where they are matching in the first two columns.
i.due east. A5 "John" matches B118 "John" therefor i want to sum C5 "450" & C118 "550", giving me a total of one thousand in both D5 & D118.
I would so also similar to add together an actress condition where information technology only needs to match the criteria in an additional columns.
i.eastward. let say column E. Both E5 & E118 must be "xyz", else column D volition not sum D5 & D118.
Thank you
-
DISMAS says:
Which formula should I employ when issuing rates to water consumers past using dissimilar rates?
-
Nageshwar Nagpure says:
Dear Sir,
I need your help on following formula,
IF A1=A and If B1>26 and so rate should be 400, only if A1=B and if B1>26 then rate should be 380
IF A2=A and if B1>22 then rate should be 380, only if A2=B and if B2>22 then rate should exist 360delight share which formula to exercise this kind of piece of work with multiple conditions
Nageshwar
-
Giebelle says:
=IF(AND(G71="*(G11)*",BC71="ABM*"),BB71,"x")
=IF(AND(G71="*(G11)*",BC71="ABM*"),"Please schedule interview","x")I thought I understood your instructions, simply when I tried information technology... waaaaa
Column Chiliad contains responses on level applying for while column BC contains the specific preferred strand for senior loftier school level. So that if column G says 'Class Eleven (G11)' and cavalcade BC says 'ABM - Accountancy, Business, and Management' then the text in the BB cell should appear or in another cell I tried making information technology the sentence appear, "Delight schedule interview" -
Robyn Walsh says:
Hi in that location!
Looks for assistance with this:
IF 0.01to 1.00 then value +1
If 1.01 to two.99 so value /0.v
If 3 to 999.99 so value /0.6
If greater than yard so value /0.65I fabricated this, but its non quite right.....
=IF(AND(E10>=0, E101.01, E13.00, E101000.00, E10<million.00), E10/0.65, ""))))
Thanks!!-
IF(AND(E10>=0, E101.00, E10<ii.99), E10/0,five IF(AND( E10 k.00), E10/0.6, IF (AND(E10<m.00, E10<million.00), E10/0.65, ""))))
-
-
Hullo Sir,
I want one formula for below condition.
A column is truthful & weight is less than 150 then ans is 250
A column is true & weight is more than 150 then ans is "A" -
Chris says:
In sheet one I have made a tabular array which contains A1=codes; A2=description; A3=amount; A4=Availability.
In canvass 2 I have some other table merely I'm trying to type any codes on A1=Codes just A2 wont autofill. What formula do I need for it to recognize and autofill the description linked from sheet 1. -
RoRo says:
OK, I have two companies, "A" and "B". Each company has vehicles: "PU", "ST", "TK", "TT". Company "A" uses fuel profiles, "001", "002", "003", and "004" (Respectively, "PU" uses "001"). While company "B" uses fuel profiles, "005", "006", "007", and "008". What formula would I use to let me to, from a drib down menu in column A select company "A" or "B", from column B, from a drop downwards carte, select vehicle - "PU", "ST", "TK", "TT" and have it auto populate the fuel contour?
-
Gene says:
I am a new Excel user. I am request hither because I assume I need to use the IF argument with others. I accept a Upkeep worksheet plus 12 (monthly) worksheets logging expenses in iii categories (exp codes), all in the same workbook. In the Budget worksheet, how do I tell prison cell E4 to look at column H of each of those 12 worksheets, and if exp code 1 is in cell H16-H36, than add together the amount in cell J16-J36 to cell E4 in the Budget worksheet? Then each calendar month as I log my expenses, the Budget worksheet will update showing how much of my upkeep I accept spent for that exp code. Hope that makes sense. If another post is more appropriate, then apologies, delight straight me at that place. Thanks.
-
-
Thank you, Mr Trifuntov. That looks exactly like what I demand. I will come back if I get stuck, just cheers for your help. (This website is a new resource for me. I found it with Google, and take bookmarked it.)
-
-
-
Joshua says:
If I have 100 individuals with unique names and each person is assigned a prepare of serialized equipment that they need to exist deemed for while traveling, however I need to be able to motion them from vehicle to vehicle on my roster, how can I create a IF, So that will fill up in the cells according to their proper name.
Example
Smith James Charles has tool box 234383 and laptop HP2175 and widget 7777348. Today James is in vehicle 1103 but tomorrow he is going to be in 3415. I don't desire to have to re-create and paste all his info into multiple sheets, I want the sheets to recognize "Smith James Charles and then prefill all the cells accordingly.
Is this possible in Excel?
-
Kaushal says:
Hey,
can I not use a condition for range in nested IF's. For example, I take a column with loan corporeality and I am classifying them into Depression, High and Very-high equally per the corporeality. Then my Formula is :=IF(1100 <G2< 10000,"Depression Charge", IF(10001<G2<20000,"Medium Accuse", IF(20001<G2<40000,"Loftier Charge", IF(40000<G2," Very High Charge", "Due north"))))
So, I am trying to say that the the cell containing the Loan corporeality (G2) falls between a range, so spend a specific value.
Just the result I get is always "Northward", which is the output when the condition is non true.
Please Check. Thanks -
Nena says:
Hullo,
Formula for this 1 please..
I desire that if a number is > or = 60000 the result will be 900 only If the number is beneath 60,000 it will be multiplied by 3% of that numberI done this 1.. the number in a higher place and equal to 900 is correct but below 60000 , information technology gives three% answer, ( not the 3% of that number as expected)
IF((OR(DS10>=60000,DS10>60000)),"900","*3%")
-
Taz says:
Hi all.
Please help.Column A would need a wild card to expect up the discussion ROLL. cavalcade B would have a size e.g 2000 and column C would have a quantity.
Basically I demand if A1 contains "ringlet" and so if B is greater than 2000 just less then 3000 to render the value in C1 (qty).
Thanks -
Dominic says:
Hi, I am using these ii formulas in two carve up cells in excel and they piece of work fine, however I would like to employ them in ane cell using maybe an IF OR formula or whatsoever other formula.
=IF(H310%,100-(H3-10)*2)
The first formula cell returns 100% accurately and the second formula jail cell returns False which is also accurate, however tin i combine both formulas in one prison cell to requite me the respond for either?
Thanks in advance
-
Char says:
Hello There,
I am trying to create an if argument where if two cells are not equal a calculation using cells within the aforementioned canvas is provided.
if M12-L12=0, give me cell E12, nevertheless if they are not equal give me (M12-L12)*E12.
Are you able to assistance? It would be very much appreciated.
-
Rehab Ali Mohamed Kamal Eldin says:
Hello
I have a formula and sometimes gives me the right respond, merely in some cells give me (FALSE)
=IF((BN10>BV10),IF(AND(BN10>BW10),IF(AND(BN10>BX10),IF(AND(BN10>BY10),IF(AND(BN10>BZ10),IF(AND(BN10>CA10),"Not Aligned","Aligned"))))))
-
=IF(G4<-81.07,1.2,IF(G4<=-136.18,1.i,IF(G4<=-170.67,1,IF(G4<=-205.16,0.9,IF(G4<-239.65,0.8)))))
Kindly help I'm trying to equate losses with the specified targets what could be the event?
-
Art says:
Please help.
my journal
A B C D E
L or Due south Entry TP SL No of units
(IF A = "S" so B - C and if C = 0 then D - B) IF A = "50" then C - B and
if C = 0 then B - C)
I hope Im clear.
Thank you.
Art -
Kayle says:
Hey there,
I take a tabular array with 2 columns I would like to compare:
Cavalcade A: On business relationship (either Yes or No)
Cavalcade B: Deposit (if account condition is Yes, so this should be blank, merely if account status is No, there should exist a deposit corporeality)
I would like to highlight the cells in column B that are blank AND business relationship status is No. This will highlight all of my not-account files that require a eolith.
Hopefully, this makes sense!
-
What's wrong with my formula.
=IF(G2>=104.53,"ane.2",IF(G2>=95.82,"ane.1",IF(G2>=87.1,"1.0",IF(G2>=78.4,"0.9",IF(AND(G2>=1,G2<=69.69,"0.8"))))))
-
Md Imteyaz says:
I desire to practise TDS calculation, kindly assist me for this
01) if Column M2- Department 194 J and Column K2 is Alphabet - P then Effect 10% and
if column M2 - Department 194 C and Column K2 is Alphabet P and so result 1% and
if column M2 - Section 194 C and Column K2 is Alphabet F then result 2%
if column M2 - Section 194 C and Column K2 is Alphabet C then result 2%
if column M2 - Section 194 I and Column K2 is Alphabet P and so outcome 2% -
Carly Forrester says:
I'thou trying to runway task priority based on due dates
IFS(OR(H4=TODAY()+21),"High","Low","Medium")
-
NDhelp says:
Hi I'm trying it do an If AND Or formula
Situation If carrier1 is James and Mode is water then Yes otherwise Jo Just if carrier is Harry and Fashion is Road then Yep. Otherwise No. Harry volition only always exist Road only James tin can be different modes.My formula is showing
=IF(AND(OR(W7="James", AG7="water"), OR(W7="Harry")), "Yes", "NO") -
Ravjit Bains says:
Hello Im creating a excel worksheet i need a little help,
Commutation Charge per unit
K1=one
K2=ane.30Issue in: E1
IF A1 dropdown "CAD" and B1 Dropdown "CAD" - then Cost C1*K1
IF A1 dropdown "USD" and B1 Dropdown "USD"- and so Cost C1*K1
E1= Calculation + D1Effect in D1
IF A1 dropdown "USD" and B1 Dropdown "CAD" - then Cost C1*K2
IF A1 dropdown "CAD" and B1 Dropdown "USD" - then Price C1/K2
D1=Return with calculation corporeality else return with 0 (if in a higher place conditions aren't met)How can i do this please assistance
-
Babe Yousuf says:
Can i utilise more 100, if in a formula, I am sending the examples
IF(B2="A&B ASSOCIATES",10,IF(B2="A.P. KAKKU ASSOCIATES",vii,IF(B2="AARUSHI TRADING COMPANY",thirty,IF(B2="ABDULLA FISH",0,IF(B2="ABISIL AGENCIES & DISTRIBUTOS",2,IF(B2="AJMAL CHICKEN",0,IF(B2="AJMAL MEAT Middle",0,IF(B2="AJMAL MUTTON",0,IF(B2="AKSHAYPRABHA TRADERS",15,IF(B2="AKTSCS LTD NO.R 109 -LOCAL Buy",0,IF(B2="ALAPPAT AGENCIES",xxx,IF(B2="ALFIN AGENCIES",30,IF(B2="AMBILI TRADERS",thirty,IF(B2="AMRITH FOODS",30,IF(B2="AMRUTHA TRADING CO.",30,IF(B2="Affections AGENCIES (MODERN Bread)",10,IF(B2="APEX Assembly",30, IF(B2="ARIMBOOR TRADERS",15,IF(B2="ASHIQUE ENTERPRISES",15,IF(B2="ATOM MARKETING",15,IF(B2="BABU Craven & MEAT",0,IF(B2="BACKIAM Business CORPORATION",30,IF(B2="All-time TRADINGS",0,IF(B2="BISMILLA MEAT CENTRE",0,IF(B2="Bliss TRADERS",20,IF(B2="BRANDMARK ASSOCIATES",30,IF(B2="Vivid PHARMA",30,IF(B2="BRM ASSOCIATES",30,IF(B2="C SALES",fifteen,IF(B2="C.J.AGENCIES",0,IF(B2="C.Chiliad. VERGHESE",0,IF(B2="C.Fifty.FRANCIS SON",15,IF(B2="CADAS GROCERY",15,IF(B2="CAKES WITH The states",0,IF(B2="CEE KAY ASSOCIATES",xv,IF(B2="CHETTUPUZHAKKARAN AGENCIES",xv,IF(B2="CHINTHALAYA AGENCIES",vii,IF(B2="CHITTILAPPILY HARDWARES",0,IF(B2="CHIYYARAM FISH HUB",0,IF(B2="COCOELIXIR INDIA PVT LTD",30,IF(B2="CREMBERIE FOODS PVT LTD",ten,IF(B2="CRUNCHY FOODS, THIRUVANANTHAPURAM",10,IF(B2="DAVID TRADERS - LOCAL PURCHASE",0,IF(B2="DEEPAM AGENCIES",15,IF(B2="DOUBLE HORSE FOODS",15,IF(B2="DREAM Cream",xv,IF(B2="E.Fifty. JOSE & Visitor",xv,IF(B2="EASTERN CONDIMENTS PVT LTD.",5,IF(B2="ELITE AGRO SPCL",15,IF(B2="ELITE BREAD",10,IF(B2="ELIXIR EXOTIC FOODS&ALLIED PRODUCTS",xxx,IF(B2="ERCMPU THRISSUR DAIRY",0,IF(B2="EVERGREEN DISTRIBUTORS",30,IF(B2="Actress HOME CARE PRODUCTS",30,IF(B2="V STAR MARKETING",10,IF(B2="FORA TRADING CORPORATION",30,IF(B2="FORTUNE DISTRIBUTING Company",30,IF(B2="FRESHNUTS",30,IF(B2="Chiliad&G IMPEX",10,IF(B2="GALORE Trade LINKS",10,IF(B2="GARUDA MARKETING",6,IF(B2="GLOBAL TRADING EAGER",10,IF(B2="GODWIN AGENCIES",15,IF(B2="Gold Chicken Middle",four,IF(B2="GOODMORNING AGENCIES",7,IF(B2="GOODWAY Associates",xv,IF(B2="GOPI VEGETABLES",0,IF(B2="H & C PUBLISHING House",45,IF(B2="HARITHA AGENCIES",5,IF(B2="Dwelling house CATERING",7,IF(B2="HOT OVEN",fifteen,IF(B2="HOT OVEN FOODS",15,IF(B2="HUL - Mod Staff of life JOBY",vii,IF(B2="HY - SON ALLIED PRODUCTS",36,IF(B2="HYSON",35,IF(B2="Platonic OFFICE STATIONERY",ii,IF(B2="IGNATIOUS MARKETING AGENCIES",10,IF(B2="ISSACSON",v,IF(B2="J.Yard. GLOBAL MARKETING",10,IF(B2="JADE Printing SOLUTION",10,IF(B2="JAICO AGENCIES",ten,IF(B2="JAS N CHARLES",ten,IF(B2="JEESON E.J - EGG MART",10,IF(B2="JENMA AGENCIES",x,IF(B2="JINIL PEECHI",10,IF(B2="JJ FOODS 'Northward' MARKETING",5,IF(B2="JP POULTRY Farm (JIJO NADEN EGG)",v,IF(B2="JYOTHI Chemical INDUSTRIES",x,IF(B2="K.C. ENTERPRISES",7,IF(B2="K.R.FOODS",15,IF(B2="KAIRALI",15,IF(B2="KALINDI ELECTRO SYSTEMS KANIMANGALAM",15,IF(B2="KARTHIKA CAKES",xv,IF(B2="KARTHIKA Fries",xv,IF(B2="KATTUKARAN DISTRIBUTORS",15,IF(B2="KBC PRODUCTS",xv,IF(B2="KC ENTERPRISES LOCAL PURCHASE",fifteen,IF(B2="KERALA SALES CORPORATION",fifteen,IF(B2="KITCHEN WORLD",15,IF(B2="KOLLANNUR AGENCIES",15,IF(B2="KOTTARAM TRADING COMPANY",15,IF(B2="KRIPA Chips",15,IF(B2="KRISHNA COFFEE WORKS",15,IF(B2="KRS MILK PRODUCTS",10,IF(B2="KUNNUMMATHARA AGENCIES",10,IF(B2="LAKSHMI FOOD Product",10,IF(B2="LEADER AGENCIES",10,IF(B2="LINIMAS AGENCIES",10,IF(B2="LOCAL PURCASE-IDEAL OFFICE Stationery",10,IF(B2="LOCAL PURCHASE",10,IF(B2="LOCAL PURCHASE - EGG",vii,IF(B2="LOCAL Purchase - RAGAM",5,IF(B2="LOCAL PURCHASE -FAZAL",8,IF(B2="LOCAL PURCHASE KATTOKKARAN",4,IF(B2="LOCAL PURCHASE KUNNAMKULAM",8,IF(B2="LOCAL PURCHASE-K.C ENTERPRISES",8,IF(B2="LP - Option FANCY",8,IF(B2="LP BROTHERS TRADING KUNNAMKULAM",4,IF(B2="LP CHITTILAPPILY HARDWARES",four,IF(B2="M M DISTRIBUTORS",4,IF(B2="MAHADEV Agency",4,IF(B2="MANDUMPAL ENTERPRISES",4,IF(B2="MANJILAS FOOD TECH PVT LTD",4,IF(B2="MARIYA AGENCIE (PARLE)",4,IF(B2="MARIYA AGENCIES (SPRITE)",4,IF(B2="MARIYA AGENCIES LOCAL Purchase",four,IF(B2="MARIYA TRADERS",4,IF(B2="MARUTHI Marketplace MOVERS",4,IF(B2="MARVEL ENTERPRISES",4,IF(B2="MAS BAKERS",iv,IF(B2="MATHRUBHUMI",iv,IF(B2="MERGER ENTERPRISES",4,IF(B2="MMC - MALAYALA MANORAMA Company LTD.",,IF(B2="MMP - MALAYALA MANORAMA PUBLICATION",,IF(B2="NANDU GAS AGENCIES",,IF(B2="NEENU S' STITCHING Centre",,IF(B2="NEW PRIME DISTRIBUTORS (ICECREM)",,IF(B2="NIRMAL AYURVEDIC PRODUCTS",,IF(B2="NYLE TRADERS",,IF(B2="OASIS TRADING COMPANY",,IF(B2="OMANA TRADING COMPANY",,IF(B2="P.K. AGENCIES",,IF(B2="P.Grand.A.FRUITS LIMITED",,IF(B2="PALOKARAN AGENCIES",,IF(B2="PARVATHI MILK",,IF(B2="POLY GUARDS EQUIPMENTS AND TOOLS PVT.LTD",,IF(B2="Pop PLAZA",,IF(B2="Prime number AGENCIES",,IF(B2="Prime number DISTRIBUTORS DABOUR",,IF(B2="PUNNYAM BAKES",,IF(B2="PUSHPA GOPI (VEG)",,IF(B2="PUTHUR - EGG",,IF(B2="RENJU (UNNIYAPPAM)",,IF(B2="ROSE AGENCIES",,IF(B2="RUCHI PAPPAD",,IF(B2="S&S AGENCIES",,IF(B2="S.One thousand.Cake Firm",,IF(B2="SABARI DISTRIBUTORS PVT.LTD",,IF(B2="SAFA",,IF(B2="SAFA FRUITS & VEGETABLE",,IF(B2="SAJ AGENCIES",,IF(B2="SALES WINGS",,IF(B2="SALVA FOOD AGENCIES",,IF(B2="SAMRITHI Food CRAFTS",,IF(B2="SARGAM ENTERPRISES",,IF(B2="SEBY M.B EGG Centre",,IF(B2="Choice FANCY-LOCAL PURCHASE",,IF(B2="SERAPHINE DEV IMPEX PVT.LTD",,IF(B2="SEVANA HYGIENE PRODUCTS PVT.LTD",,IF(B2="SHASTHA PAPPADAM",,IF(B2="SREE MUKAMBIKA PRODUCTS",,IF(B2="SREE MURUGA TRADERS",,IF(B2="SREE SELVAGANAPATHY MILK PRODUCTS",,IF(B2="SREEKRISHNA ENTERPRISES",,IF(B2="SREEMOOLAM AGENCIES",,IF(B2="ST.ANTONYS AGENCIES",,IF(B2="STARLINE AGENCIES",,IF(B2="SUPRABHATHAM FOODS",,IF(B2="SURILEE AGENCIES",,IF(B2="SV FOODS",,IF(B2="SWAAD FOODS",,IF(B2="TCM RICE&SPICES",,IF(B2="THARAKAN AGENCIES",,IF(B2="THARAKAN Assembly",,IF(B2="THAZHATH AGENCIES",,IF(B2="THOLUR TRADINGS",,IF(B2="THOTTANS Nutrient &NUTRITIOUS",,IF(B2="THOUFEEQUE TRADERS",,IF(B2="Three STAR TRADERS",,IF(B2="TKM MARKETING",,IF(B2="Elevation PHARMA",,IF(B2="TRICHUR MARKETING AGENCY",,IF(B2="TRICHUR SALES INTERNATIONAL",,IF(B2="UNITED AGENCIES",,IF(B2="UNIVERSAL BUSINESS CORPORATION",,IF(B2="V4 MARKETING",,IF(B2="VAISHALI MARKETING",15,IF(B2="VARSHA DISTRIBUTORS",15,IF(B2="VEEYES AGENCIES",15,IF(B2="VIJAY TRADERS, THRISSUR (CAICO)",15,IF(B2="VINVIEW TRADERS",fifteen,IF(B2="VISWAM AGENCIES",fifteen,IF(B2="VX Associates",15,IF(B2="WIMBIS KITCHEN 2021-2022",0,IF(B2="WINCO AGENCIES",15,IF(B2="WINGS ASSOCIATES",xv,IF(B2="WINNER AGENCIES",7,IF(B2="Magician Associates",7,IF(B2="ZEBRA OFFICE FILE",30,IF(B2="ZOOM ENTERPRISES",10,-
Einvest says:
I think its ameliorate to used lookup role for this volume of data
-
-
Minh Nguyen says:
If I have
column A Column B
25
25
25.25
24.5
54
54
54and in column B I want to calculate 'If A2="25,54", and then plus 2 otherwise +6. I desire to isolate specific number to plus two and the rest plus 6.
I tried = IF(A2=25, A2+2, A2+6) but it only applied for 25 to plus two, just the rest of the number is plus half dozen. How practise I get the 54 to plus two besides? -
David says:
Trying merely not succeding....
Trying to make a calculation based upon a letter in a cell. I have a unmarried adding figured out, but i want to add another condition.
Here is my original formula: =IF(M35="Y",F35*70%,F35*65%)Now I want to add if M35=D, so multiply by 100% and keep the rest above too.
-
OK, after relentless searching online, I finally figured it out.
This is what I put: =IF(M35="Y",F35*lxx%,IF(M35="D",F35*100%,F35*65%))
It works, then I'k happy.
-
-
peter north says:
Hello!
how can I go the formula for this,
I desire to show the output of this available,discontinued,N/A
become like this available,Out of Stock,Not available in daily update,The discontinued will be Out of Stock and the N/A will be Not bachelor in daily update.
Thankyou for helping me.
-
Cynnex says:
I think what you lot wanna say is to change the way a formula express such every bit:
Discontinued-->Out of Stock
Northward/A-->Not available in daily update
You tin can customize your own expression by using "things that you wanna say" in the formula.
example were in the content in a higher place.hope this helps.
-
Mail service a comment
Source: https://www.ablebits.com/office-addins-blog/2014/12/03/excel-if-function-iferrror-ifna/
Could y'all please be able to assistance me write an formula for IF B2 is Yeah, then information technology should retrieve the data present in A2, if B2 is NO, then it should be blank