Comments on: Excel IF statement with multiple conditions

For powerful data analysis, you may often need to build an Excel IF statement with multiple conditions or use IF together with other functions. This tutorial will show you the most effective ways to do this. Continue reading →

Comments page 25. Total comments: 4553

  1. My question is that how I can use IF with "OR" "AND" to give me the result like:
    Admin dept "yes"
    HR dept. "No"
    Securityguard " under consideration"
    Or you can suggest another logical formulas..thanks

  2. I need to find an excel formula that will take a number in a cell (example "a1") and rounds up to the nearest hundredth. It's for product increases and the number has to be even. Like $3.28, not $3.27. If I have the number $3.333 I need it to round up to $3.34. Can this be done in Excel?

    1. Hello!
      You can learn more about rounding numbers in Excel in this article on our blog.
      There you can find a formula like this:

      =ROUNDUP(A2,2)

      This should solve your task.

  3. Hi! I could have sworn I've been to this site before
    but after browsing through some of the posts I realized it's
    new to me. Nonetheless, I'm definitely happy I came across it and I'll be bookmarking it and checking back regularly!

  4. =IF((AND(I3="No",N3="Good IMU")),"Action - Feeds",""),IF((AND(I3="Yes",N3="Low IMU")),"Action - IMU")

    Can someone please help - I need 2 different return values based on 2 different and statements. help!! I can get one or the other, but I don't know how to combine into one formula!

    1. Hello!
      You can learn more about nested IF and multiple conditions in a single formula in this article on our blog.

      =IF((AND(I3="No",N3="Good IMU")),"Action - Feeds",IF((AND(I3="Yes",N3="Low IMU")),"Action - IMU",""))

  5. Hi,
    I need some help, what I`m trying to achieve is based on 4 cells. the first being a salary amount and then the next two cells (1 x figure and 1 x %) with the forth being the grand total.

    So If I wanted to give an employee a salary increase, for example; rather than give £5k in the second cell, I just enter a % in the third cell. However I would like the total salary amount to calculate the total increase whether it be a £ or % increase.

    Hope the above makes sense

  6. Hi, is it possible to generate percentage on excel with multiple arguments based on the data populated each day?

  7. I need if formula with logic if A1 column is blank data pick from A2 column
    Thanks in advance for supporting

  8. hi, is it possible to put number 1 or 2 in c1 while i used this formula in the same cell =IF((C1)=1,"I",IF((C1)=2,"II",IF((C1)=3,"III","blank")))

    i just want to put number then its automatically change or convert to text which i want it, Help me pls

      1. thanks

  9. How do I check if Column A has different values in Column B.

    E. G Apples in Column A has both fruit and veg in column B.

    Thanks

  10. I would like to create an IF statement saying in effect if a certain cell or range) is black then add it(or range) and if it is another color then deduct it.

  11. Hi there,

    I am looking to do an IF function to display a percentage. So if Cell A1 is less than 5,000 then its 8%, if its bewteween 5000 and 15000 its 10%, if its between 15000 - 40000, then its 15% and so on and so forth.

    How do I do this?

  12. HOW COULD I DO AN EQUATION THAT STATES "IF B6 IS BETWEEN 0 AND 10, THEN MULITPLY B6 BY .20,, IF B6 IS BETWEEN 10 AND 20, THEN MULTIPLY B6 BY .22,, IF B6 IS BETWEN 20 AND 30, THEN MULTIPLY B6 BY .24, ETC.....

  13. Hi,

    I am looking for an if, else function formula in excel that can identify who will "win", or "loss" in the sample situation below?
    Score
    Player #1 - 5
    Player #2 - 1
    Player #3 - 8

    In the result, Player #3 should be "win", and Player #1 and #2 should be "loss" . Is there a possible if, else formula for this? Thank you.

    1. I'm trying this formula (where H is the column in excel) ,data in H3 is 5, H4 is 1, H5 is 8
      but the result is not correct , it resulted to win, where it should be loss.

      =IF(H3>H4,"win",IF(H3>H5,"win","loss"))

      Thank you, appreciate your reply.

  14. Hello,
    can you help me to write formula that if cell B6 is:
    between 1201 to 3200, write in cell B20 number 125
    between 3201 to 10000, write in cell B20 number 200
    between 10001 to 35000, write in cell B20 number 315
    between 35001 to 150000, write in cell B20 number 500

    Appreciate your help.
    thank you
    Milan

  15. A formula for if N13=** OR * SHOW 'Y' AS RETURN VALUE

  16. I have a table sheet (CMT) with formula. it was created to monitor patient clinic attendant. I want to create other sheets that will extract data from my original table sheet (CMT). For example, I want to have a sheet that will show list of patient due for clinic appointment for the present month base on the table formatting.
    What excel techniques will I use to create such automated sheets from my table sheet?

  17. (+/-) 6 - 10% (+/-) 1 - 5% 100%
    1,000 1,500 2,000
    how to create formula that should result into this
    90% 1,000.00
    91% 1,000.00
    92% 1,000.00
    93% 1,000.00
    94% 1,000.00
    95% 1,500.00
    96% 1,500.00
    97% 1,500.00
    98% 1,500.00
    99% 1,500.00
    100% 2,000.00
    101% 1,500.00
    102% 1,500.00
    103% 1,500.00
    104% 1,500.00
    105% 1,500.00
    106% 1,000.00
    107% 1,000.00
    108% 1,000.00
    109% 1,000.00
    110% 1,000.00

    1. Hello!
      If I got you right, the formula below will help you with your task:

      =IF(ABS(A1-100%)>5%,1000,IF(A1=100%,2000,1500))

  18. Hi,
    could some one help me to create a formula - if my loss is less than 2%, 100 marks, if my loss is between 2.1 to 2.5, 80 marks, if my loss is more than 2.4 - 0 marks

    1. Hi!
      I hope you have studied the recommendations in the tutorial above. It contains answers to your question.

  19. hello, 1st I'd like to say I found this site very interesting; so great that you're willing to help !

    here's my question.. I have 2 lists in a column, for example, 8,6,2,-2,-4 and the second list 5,3,-2,-4,-6. now if I multiply by rows I get 40,18,-4,8,24. The issue here is that the list a ranking of points in game for 5 people. based on the 3rd column, the dude with -4 and -6 is ranked 2nd while he's actually 5th. one way to get around this is to multiply by (-1) if both values are negative. I wanted to know if there is a IF statement I can use such that (if a2<0 and b2<0 then multiply by (-1), else just multiply as usual) . I'm aware that another way to get around it is to just add the values then both negative values would remain negative; I just wanted to know if I could multiply by (-1) . that's it ! thanks for reading this. hope to hear from you this week.

  20. Thank you!!!

  21. Hello, i want to make a formula that shows me a number of 13 rows based on two criteria. One of them is
    " =IF(M3="monofazat",(R10) " and i want to put that 13 rows in " R10 " place. In the same row i want to make another criteria that sound like this " =IF(M3="trifazat",(T10) "and also shows e another 13 rows. When i write in "M3" this texts ( "monofazat" or "trifazat") i want that rows to appear in the one i write the formula. I want to make some ofertation table, to be more simple to make an offer to a client. It's possible? Thanks, i m waiting for an answer!! Have a nice day!

    1. Hi!
      Based on your description, it is hard to completely understand your task. However, I’ll try to guess and offer you the following formula:

      =IF(M3="monofazat",A2:A15,"")

      If this is not what you wanted, explain in more detail, write an example of the result.

  22. There will be a given data of a person with their Height, Weight and Mid upper arm circumferance , from that we have to derive whether the child is Severe Accute Malnutrition or Moderate Accute Malnutrition or Normal or Obese. What will be the formula in Excel . Length (cm) "SAM
    < –3""MAM ≥ –3 to +2 to ≤ +3" "Obesity> +3"
    Weight (kg)
    45 0–1.8 0–1.9 1.9 2.0–3.0 > 3.3
    46 0-1.9 2.0–2.1 2.2–3.1 3.2–3.5 > 3.5
    47 0–2.0 2.1–2.2 2.3–3.3 3.4–3.7 > 3.7
    48 0–2.2 2.3–2.4 2.5–3.6 3.7–3.9 > 3.9
    49 0–2.3 2.4–2.5 2.6–3.8 3.9–4.2 > 4.2

    1. Hi!
      The result you want to get me is incomprehensible. But recommendations from this article will be useful for your formula.

  23. I need a formula that can look at value in B column (there will be up to 10 different values in this column)
    and return a different result in the next cell of column C IE: cell b1 = text then c1 = text2

  24. Hi There!
    Looking for some help.

    I have a scoring card and need to calculate points on a ranking scale. What would be the correct formula for the below.

    Score is 20 or less receive top points, if score is higher than 20 subtract point. (-2)

    =IF(D920,$F$34,(D9*F$34)/20-2))
    OR
    =IF((D820,$F$34,(D8*F$34)/20),-2))

    Thanks

    1. Hi!
      Unfortunately, without seeing your data it is impossible to give you an exact formula. Your conditions are not entirely clear to me. But you can do this if you carefully study the instructions in this article above.

      1. Hello,

        We need to check value of two column and IF BOTH ARE POSITIVE "LB",if 1st is negative and 2nd is positive "SB",if both are negatie "LU" else "SC")
        1st 2nd
        -1.62% 169.90% LB
        2.01% 44.29% SB
        -0.78% 15.46% SB
        -0.74% 7.80% SB
        -0.10% 4.16% LB
        1.95% 2.91% SB
        -0.19% -1.32% SB
        0.89% 1.92% LB
        3.11% 1.33% SC
        -1.47% -7.96% SC
        2.25% 3.83% SC
        -0.85% -2.97% SB
        0.41% -3.17% SC
        0.05% 0.42% SC
        -0.07% -3.88% LU
        -0.61% -3.52% SB
        0.49% -2.44% SC
        -0.95% -0.84% LU
        -2.37% -5.69% SC

        Please help me with correct formula.

        1. Hello!
          I hope you have studied the recommendations in the tutorial above. It contains answers to your question.

  25. I want to put the "statements in column 2" when I select "items in column 1" from menu bar in another sheet.

    Column 1 Column 2
    item1 sample for statement1
    item2 sample for statement2

    I tried pivot table, but it provides statement upto some extent, I need to display the whole statement in column 2, no matter how bigger it is. Please help!

  26. I had read all the examples, and maybe I miss it but I can't figure it out a formula:

    If the value of cell A1 is equal or more than 10% the amount will be $500.00 but if the same cell is less than $500.00 it will be 10% less. Can you please help me? I do appreciated

  27. Hi,
    I have a spreadsheet with a Table tab and a Data tab. In the Table I have a persons name and then columns for each different inspections that are completed - I'm trying to work out whether a VLookup or a some sort of IF or SUMIFS variation can be used to search the information in the 'Data' tab. Colum C in Data is the names and D is the type of inspection. The Data is C3 : C20 (names) and D3 : D20 Inspection type (example 'Assurance - Task Inspection') I need the table to have = QTY of John Smith's Task Inspections. Ideally I would like to include in the formula 'name' and 'inspection type' as the report evolves and we include more people or inspections all that would need to be changed is the formula 'name' reference or 'inspection type' reference.
    Note: The data tab will be copied from a system report and pasted into those rows everytime

      1. Thanks Andrew,
        I managed to work out a SUM and COUNTIF combination and trial and error the formulas until it worked out.

  28. Thank you very much guys, this article was very helpful in getting me to complete an urgent caluclation.

    well explained and simple.

    Many thanks

  29. Hello ,

    Could you please help me on the below formula? I'm trying to define the below rule:
    The formula that I have defined is this =IF(K2>=I2,"Achieved",IF(K2<I2,"Not Achieved"))
    but I need to add another condition so if the method of meeting colum2 is Phone Call whatever value it might have not to be calculated as Achieved.

    2 Meeting 1 Not Achieved
    1 Meeting 0 Not Achieved
    6 Meeting 6 Achieved
    6 Meeting 6 Achieved
    6 Meeting 2 Not Achieved
    6 Meeting Not Achieved
    1 Meeting Not Achieved
    0 Phone Call Achieved

    1. Hello!
      If I understood correctly, add the condition to the formula

      =IF(J2="Phone Call","Achieved",IF(K2>=I2,"Achieved",IF(K2<I2,"Not Achieved")))

  30. Hi, i have been trying very hard to display the length of service for some vouchers. Appreciate your help!

    Category > = 2 Years < 2 Years
    Manager 70.00 50.00
    MT & ASM 50.00 40.00
    FT SA 40.00 30.00
    PT SA 30.00 20.00

    and it depends on the category and less than 2 years or more than 2 years.

  31. Hello I need a formula that can display multiple argument
    For example let say the display cell is C1 and what to be displayed in it is in relationship with other two cell let say A1 and B1 such that if A1 is IP and and B1 is 1.0 then C1 is 0.036 but A1 has 9 different possible conditions while B1 has 8 different possible conditions.

    1. Hello!
      This information is not enough to write a formula. However, you will be able to describe all the conditions in the formula if you carefully read the recommendations in the article above.

  32. Hello,
    I'm trying to come up with a formula that will give me the same return as the following, but include more room numbers and more sections of the facility:
    for example this formula in column A returns "North" or blank "=IF(AND(B14>209,B14<227),"North","")"

    What I would like is to have the following:

    If the value in Column B = between 202-208, and 232, Column A = North East
    If the value in Column B = between 210-226, Column A = North
    If the value in Column B = between 234-242, and 258-274, Column A = East
    If the value in Column B = between 244-256, Column A = West
    If the value in Column B = between 280-294, Column A = South

    I don't need it to return blank.

    I thank you ever so much for any help you can offer!

    1. Hi!
      I hope you have studied the recommendations in the tutorial above. It contains answers to your question.

  33. If value of C2 (in excel cell) is 210000. Take value greater than 150000 but less than 200000 in C5 (in excel cell) and if value of C2 is equal to 150000 or less than 150000 take as zero.
    Kindly enlighten with formula.

  34. Hello guys
    I have a problem that i cant solve for days. Can't find an answer on web. So here is what i wanna do;
    There are almost 250 pieces of products i have and all have names and codes
    (e.g name:15cm silver furn. leg and code: ob0001)
    I want to enter the name of one products in a random cell and excel will automatically enters the code in the next cell.

    Its all but i cannot make it work. im about to smash my computer (:

    Is there a solution? Please help me!
    thanks in advance

    1. Hello!
      If the product name and code are in a separate table, you can use the VLOOKUP function to search that table. Your search for the name gets the corresponding code. Or vice versa.

      1. Thank you very much.. Im gonna try this function.

  35. I'm looking for a function that will change the end date based on the number of days delayed. However, it's not as simple as merely adding the number of days to the start date. There are two stakeholders involved such that if stakeholder "A" has a delay of 30 days, stakeholder "B" or the result is only impacted by 12 days. Would you please suggest a function for this and tell me how to use it? Thank you.

    1. Hello!
      I am not sure I fully understand what you mean. Explain in more detail, give an example of the source data and the desired result.

  36. Please enlighten the excel formula to calculate following problems:-
    If value of C2 (in cell) is greater than 150000 than takes value greater than 150000 but less than 200000 and if value of C2 is equal to or less than 150000 ignore it.

      1. Thanks for speedy replied.
        My question is that employees are submitting Income tax saving documents such as Rs.100000, Rs.134000, Rs. 200000, Rs.260000, etc. varies from one employee to other. Exemption limit admissible is Rs.150000 only irrespective of saving documents submitted by them under particular section. If employees submitted saving documents for Rs.120000, the whole amount is exempted as it is less than Rs.150000 (maximum permissible exemption) but if employee submitted saving documents for Rs.210000, his exemption is limited to Rs.150000 as per Rules. However, saving documents beyond Rs.150000 subject to a maximum of Rs.50000 can be exempted under another/difference section (beyond 150000 upto 50000). As the employee submitted saving documents of Rs.210000, he can get additional exemption of Rs.50000 in another section and excess amount of Rs.10000 to be ignore.
        My question is that an employee has submitted saving documents amounting to Rs.240000 and maximum amount of Rs.150000 is exempted in particular section and amount exceeding Rs. 150000 is to be exempted in another section subject to the limit of Rs.50000 only and rest amount to be ignore. However, if saving document submitted by employee is less than Rs.150000 the same to be ignore for exemption in another section. (If the value of C2 (say Rs.240000) is greater than 150000 takes value greater than 150000 but less than 200000 (i.e Rs.50000 maximum admissible) in another cell and if value of C2 is less than (say 140000) or equal to 150000 (say 150000) ignore or takes zero).
        Hope you will assist me in solving problems as the formula is to applied for more than 500 employees.

        1. Hello!
          I can help you write the formula if you give an example of the source data, the result, and accurately and briefly describe all the conditions. I don’t have the time or opportunity to try to understand the financial instructions. According to your description, I cannot help you.

          1. Thanks. Let be clear the question:-
            Say Value of C2 in Excel is 240000 but maximum limit in C2 is only 150000.
            Value exceeding 150000 in C2 is to be taken in C5 but to the condition that maximum limit in C5 is 50000 and if value in C2 is less than or equal to 150000, the same to be ignore or taken as zero in C5.
            Formula to be apply in C5 uniformly irrespective of amount of value in C2.
            Hope you are clear of my question and assist me by providing the formula.

            1. Hello!
              If I understand your task correctly, the following formula should work for you:

              =IF(C2-150000>=50000,50000,0)

  37. sir,

    pls help

    IF total of B4=1 then, appear the total of column D7 ( whatever it is.....)

    Thanks,

  38. I'm trying to create a nested IF function that includes an AND condition but get an error that says there are too many arguments. Is there any way to create a nested IF that includes an AND?

    Here are the three conditions/formulas I would like to combine to create a single output in one Status field (the word "blank" is just a placeholder so that I can see the results):

    if F2 is not blank, then return "Done":
    =IF(F2"","Done", "blank")

    if F2 is blank AND E2 is greater than 10 days, then return "2nd call":
    =IF((AND(F2="", TODAY()-E2>10)), "2nd Call", "blank")

    if D2 is blank, then return "1st call":
    =IF(D2="", "1st Call", "blank")

    Here is what I think the full formula should look like:

    =IF(F2"","Done", "blank", =IF((AND(F2="", TODAY()-E2>10)), "2nd Call", "blank", IF(D2="", "1st Call", "blank")))

    Here is a screenshot of sample data:

    https://drive.google.com/file/d/1UtB_MMrfM25MyDX-NFfqw_Zroxopdcj1/view?usp=sharing

    Thank you so much for any assistance you can provide. I have learned so much from your website. I really appreciate the hard work you've put into making these formulas easier to understand.

    1. Hello!
      Perhaps this formula will work for you

      =IF(F2<>"","Done", IF((AND(F2="", TODAY()-E2>10)), "2nd Call", IF(D2="", "1st Call", "blank")))

      1. Ah, I see what I did wrong by including the "blank" output. That does help. Thank you so much for your assistance.

  39. I need help calculating an Average for multiple subjects in one row
    e.g.
    Student Maths Science Geo

    Peter 80 80% 0 0% 78 78%
    John 50 50% 78 78% 0 0%
    Sue 60 60% 0 0% 80 80%

  40. I am trying to add an SumIF statement to my sum.

    If the Sum of A1:A4, is greater than 100, only display 100.

  41. Hello,

    I hope someone can help me with this.
    If cell C is not blank, result should be "Done"
    If the cell is blank and cell B and cell A result should be the following:
    If 15 Day Difference, "Too early"
    If 30 Day Difference, " Needed"
    If 60 Day, "Cancelled"

    Here is the data:
    Cell C:

    Policy Effective

    02/16/2021
    02/11/2021
    02/11/2021
    01/22/2021

    Cell A & B
    Cell A Cell B
    02/18/2021 02/16/2021
    02/17/2021 02/04/2021
    02/12/2021 02/06/2021
    02/12/2021 02/06/2021
    01/22/2021 01/18/2021
    03/01/2021 02/27/2021

    Thank you so much

    1. Hello!
      Please check the formula below, it should work for you:

      =IF(C1<>"","Done",IF(B1-A1<=15,"Too early",IF(B1-A1<=30,"Needed","Cancelled")))

  42. Hi,

    many thanks for the detailed tutorial here. love it!

    i have a1 linked to a drop down list from a separate worksheet.

    i want my m1 to reflect a price based on the item selected from the list in a1 (list of prices also from a table in separate worksheet)

    eg. if a1 is selected as apple, I want this to be reflected in m1. if it is selected as a orange, i want it to be reflected as such in m1.

    how would i do this please?

    many thanks in advance!

  43. Hello,

    I'd like to create a formula for the following, but I don't know how to do it.

    If status in column F is "Draft", then use the File Path in Column I to enter the file name in that folder into Column J called 'File Name'.

    Can this be done with a formula? Or is VB needed?

    Any help is greatly appreciated.

    1. Just to give more information on this. The excel worksheet lists information to track a large list of documents. Each document is kept within its own folder. The worksheet lists a lot of data for those documents including the document's status and its File Path.

      Here is the issue: Even though there is only one document in that folder, the file name of the document changes daily. So instead of updating the file names manually (which is tedious and time consuming), I'd like to use the Status column and the File Path column to automatically update the file names of those documents.

  44. Hi there,
    Im trying to return Status (to return Not Started/ Ongoing/ Done/Delayed) of a Task based on starting date, due date and today. I am stuck on adding condition for "Delayed", when Due date has been postponed.

    Today = L2
    Start Date = E3
    Due Date = F3

    I have tried using the OR formula as well, but I cannot add a 4th condition for delayed:
    =if((or(F3>L2="Delayed",E3&F3="",F3<L2)),"Done","Ongoing")

    Could you kindly assist on this question? Thank you in advance!

    1. Hi Diana,

      To check multiple conditions and output different results depending on which condition is TRUE, use nested IF functions:
      =IF(F3>L2, "Delayed", IF(AND(E3="",F3=""), "Done", IF(F3<L2,"Ongoing", "")))

  45. How to Calculate if there are 5 parties having different price how to know the which of the party has less price showing the party name

  46. Hello, this seems obvious yet I am stuck and can't find the best way to apply it in excel - pls help:

    I have two different IF functions that are working well each on its own:
    - Function1: =IF(D3="A",'Assumptions Sheet'!$O$10,IF(D3="B",'Assumptions Sheet'!$P$10,IF(D3="C",'Assumptions Sheet'!$Q$10,0)))
    - Function2: =IF(D11="A",'Assumptions Sheet'!$O$9,IF(D11="B",'Assumptions Sheet'!$P$9,IF(D11="C",'Assumptions Sheet'!$Q$9,0)))

    Question: Now, I want to combine them within another IF statement - If CELL A3 = "H" then return the result of Function1 ; If CELL A3 = "L" then return the result of Function2 .

    Thank you.

  47. Help pls. I need a formula for:

    EX: I have a number in cell B1 and if the number is 2, then transfer the number in cell A1 to H1,
    This goes on for 45 numbers. Ex: If number in cell B2 equal 5, then transfer number in cell A2 to H5. etc.

    Can anyone help pls?

  48. I'm having a tough time trying to write a formula where 2 conditions must be true, then using the value from a third formula.

    Sheet -1 (google quiz)
    Score Name Student # Class #
    10 Jim 5 6/1
    6 John 5 6/2
    6 Greg 5 6/3
    9 Tom 5 6/4

    So take the above table for example. That would be the sheet that's linked to a google form and it populates as the students take the quiz. No, I have 4 different classes, 1 sheet for each class. I'm having a hard time writing a formula where say, "condition 1 = 6/2", "Condition 2 = 1 (the student number)", and if both of those conditions are met, then the "score" is automatically populated on the roster sheet.

      1. Okay, that helps. However, I'm still having difficulty getting the score as the value.

        So I have multiple sheets that are pulling data from 1 sheet where all my google forms are populating. The google form has a cell "score (1-20)", a cell with the "student numbers (1-40)" and a cell for the "class". However, I have a sheet for each class (6/1 - 6/4), with 40+ students in each. The =AND(logical_expression1, [logical_expression2, ...]) formula highlights those cells, but I can't get it to pull the actual score (from the score cell) when both conditions are met.
        =IF(AND(F1:F100="6/2",E1:E100="1") F1:F150 being the class, E1:E150 being the students number, because each class has students numbered 1-##, there is overlap, therefore I need to have both class and student number to be true, if both of those conditions are met, then I need it to pull the score (1-20) from that specific row.

        1. If you refer to multiple cells at once in your formula (F1:F100 rather than F1), you should also wrap it in the ARRAYFORMULA.

          If you're still not sure how to make it work, please consider creating a sample spreadsheet with the following tabs: (1) a couple of sheets with 10-20 lines from your forms (if there's confidential info, replace it with some data but keep the format), (2) an example of the result you want to get.

          Share this spreadsheet with us: support@apps4gs.com, I'll look into it.

          Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

  49. Hello.
    Please I have issue with printing all carry over courses for a particular semester. It always give me the first carryover course and ignore the rest. I used the if nested conditions...
    Please what could be the reason.
    Thank You.

  50. Hi there,

    I have an issue that is along these lines but not precisely what has been discussed thus far...

    I am needing to add values together based on two other conditions being met,
    for example

    If A = 5 and B = 8 add 1 to C
    this was the formula I came up with for the above:

    IF({{a}} = 5 AND {{b}} = 8, VAL('c') + 1, VAL('c'))

    Now my issue is coming in where I need to add multiple criteria to C...
    This formula below does not work but I've used it to explain the thought process

    IF({{a}} = 5 AND {{b}} = 8, VAL('c') + 1, VAL('c')) + IF({{D}} = 5 AND {{E}} = 8, VAL('c') + 1, VAL('c')) + IF({{F}} = 5 AND {{G}} = 8, VAL('c') + 1, VAL('c'))

    Could anyone assist in a correct formula that could work. Based on the above (incorrect) formula I am trying to reach a total of 3 in C.

    Thanks in advance for the brain power.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)