Comments on: How to use IF function in Excel: examples for text, numbers, dates, blanks

IF is one of the most popular and useful functions in Excel. Generally, you use an IF statement to test a condition and to return one value if the condition is met, and another value if the condition is not met. Continue reading

Comments page 25. Total comments: 4822

  1. Hi there, I am doing a survey regarding customer satisfaction level to my restaurant. So there are three satisfaction level: A, B, C. I want to find out the problem that leads customer to grade C to our services/foods with precise date. But however I still couldnt make it. Could you please kindly help me out?
    The scenario is as below:
    Customer Satisfaction Level : A, B, C
    Date: 13-08-2020
    If "Customer Satisfaction Level:B" , so it should come out with value CSL:B13082020
    I tried with IFS formula and it is as below:
    =IFS(A2="Customer Satisfaction Level:A", "CSL:A",A2="Customer Satisfaction Level:B","CSL:B",A2="Customer Satisfaction Level:C","CSL:C")
    But however, one key problem is how should I key in DATE formula to the value_if_TRUE? Maybe any other formula that can help me on it ?

    Your help is very much appreciated.

  2. Thanks James. That did what I am looking for. Much appreciated
    Stuart

  3. hi there, i'm trying to return a value if a date is between two dates, basically trying to sort my data into quarters, so next to my date column i would like a quarter column and want this column formula driven based on a table of dates. is this possible? thank you.

  4. Hello, I am wanting to create a formula that if the value is greater than 0 then the result displays the value but if is is 0 then it displays 'unknown'. Is this possible? Thanks

    1. IF( A1 > 0, A1, "unknown")

  5. Hi,

    I am working on a table for some stats however I am wondering if there is a shorter way using an IF function to return the original value if true.

    For Example currently I use.
    =IF(SUMIFS(Forming_Bends_Data!$F$3:$F$50,Forming_Bends_Data!$A$3:$A$50,Controls!$A58,Forming_Bends_Data!$B$3:$B$50,">="&$C$24,Forming_Bends_Data!$B$3:$B$50,"="&$C$24,Forming_Bends_Data!$B$3:$B$50,"<="&$D$24))

    Im wondering if it is necessary to copy out the original string as these may need to be added to and are getting quite long.

  6. I have to produce a spreadsheet for covid19 weekly testing of staff. I want to place next due date in cell after entering y in tested cell calculating 7 days ahead from date tested. A1 =date tested, B1 =y for tested C1 = due date by 7 days. Could you assist with formula
    Thanks

    1. Hi Stuart.

      Try the following in cell C1

      =IF(B1="Y",A1+7,"")

      the "" will show as a blank cell Also dont forget to format cells to dates.

  7. helo,
    if i have multiple figures expected in acell and want to test then, how can i do it?
    example in column a, i type 1, 4, 5 9, 17, 23,and 29 an others. i want to be informed in column B that if in A there is 4, it documents y, if 5, its also y and you find that they are around 2000 figures to be tested by y. how can i set it?
    many thanks

  8. Hello,
    I want a formula that check another cell if it contains certain text and just come up with the today's date if find this text.
    Eg.: ( if cell A contains ''sent to client'' the result is 27/07/2020)

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

      =IF(A3="sent to client",DATE(2020,7,27),"")

      or

      =IF(A3="sent to client",today(),"")

      I hope this will help

  9. Hello!
    My knowledge of Excel is basic at best. Is there a way to sort data alphabetically into another worksheet? For example, if I have a list of names on Sheet 1, can I then sort that info into other sheets broken down into parts of the alphabet? EG, Sheet2 = A - H; Sheet3 = I-P; Sheet4 = Q-Z. I'm trying to create a workload list for my staff but their work is divided by alphabet. Thank you.

  10. Hi,
    I am trying to return the value of a cell if another cell is greater than an amount - it's a simple one but I cannot figure it out, can you help

    1. Hello!
      Without seeing your data it is impossible to give you advice.
      You may find this formula useful

      =IF(A1>B1,C1,"")

  11. I'm a layman trying to set-up an excel worksheet and hoping someone would be able to tell me how I would write the following formula for a dollar amount;
    If cell 7 + cell 9 is > cell 10, then cell 14 = cell 7; If not, then cell 14 = cell 10 - cell 9.

  12. Hello,
    is it somehow possible to have both text and a formula as value_if_true/false? Simple example what I mean and what is wrong =IF(A1-B1=0;"OK";A1-B1 "PIECES MISSING")??
    Thanks

    1. Hello Jan!
      You did not describe your problem very accurately. I'll try to guess.
      Perhaps you wanted to write down such a formula

      =IF(A1-B1=0;"OK";(A1-B1)&" PIECES MISSING")

  13. Question. Im trying to figure out a formula for my scheduling.
    I put the cell as AM/PM/wholeday

    AM value is 5
    Pm value is 5
    Wholeday value is 10
    What formula should i use total their hours from monday to sunday. Thank you

    1. Hello Remy!
      I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you. Thank you.

  14. OK, I MADE A HEAD WAY AROUND IT, I APPRETIATE SIR.
    THIS SYNTAX BELOW FINALLY WORKED FOR ME:
    =IFERROR(IF(J26="ON","ENUGU DISCO",IF(J26="FT","ENUGU DISCO",IF(J26="LS","ENUGU DISCO",IF(J26="PG","ENUGU DISCO",IF(J26="TP","TSP",IF(J26="IT","ENUGU DISCO",IF(J26="ET","TSP"))))))))

    ACTUALLY, THE FORMULA IS TO HELP ME DIFFERENTIATE REVENUE LOSES CAUSED BY DIFFERENT FACTORS IN AN ELECTRICITY DISTRIBUTION COMPANY I AM WORKING FOR.
    I REALLY APPRECIATE YOUR GUIDANCE OVER HERE.
    MORE GRACE TO YOU SIR.

  15. please I have a challenge using multiple IFS formula when dealing with strings, it returns parse error or #error. the example below:
    =IFS(J4>="ON","NOT APPLICABLE",[(J4>="FT","ENUGU DISCO")],[(J4>="LS","ENUGU DISCO")],[(J4>="PG","ENUGU DISCO")],[(J4>="TP","TSP")])

    1. Unfortunately, without seeing your data it is hard to give you advice.
      Remove all extra brackets.

      =IFS(J4>="ON","NOT APPLICABLE",J4>="FT","ENUGU DISCO", J4>="LS","ENUGU DISCO",J4>="PG", "ENUGU DISCO",J4>="TP","TSP")

      Maybe it will help

  16. hello,
    i want to know the formula to calculate the diffrence in time to calculate lateness for staff.
    time in is 07:30 am
    time out is 17:00 on monday only
    time out is 16:45 tuesday to friday
    how can i calculate the overtime, lateness and for the early out.
    can you please provide me a formula.
    thanks in advance
    Regards,
    Krish

  17. Hi Alexander,
    I am trying to get a Region based on two condtions: Animal and Month.
    You choose animal in I3 and month in K3.
    The list of animals is in D6:D15, the list of months is in E6:E15, the list of regions is in F6:F15.
    Multiple animals and months can appear at the same time, in two different regions.
    However, the code I am trying to enter does not return the region as I want.
    =IF(AND(D6:D15=I3;E6:E15=K3);"ok";"fail")

    It's a rather simple code, but I just can't seem to get it to work.

    Hope you have an idea. Thanks! :)

  18. well i can't change some number like 1-1.000.000.000.000,00 into a text like:
    234.567.891 into (Dua Ratus Tiga Puluh Empat Juta Lima Ratus Enam Puluh Tujuh Ribu Delapan Ratus Sembilan Puluh Satu - indonesian) or (Two Hundred thirty Four million Five hundred Sixty Seven Eight Hunred Ninety One - english).
    will someone help me?

  19. Hi Alexander,
    I'm trying to write a countif formula to only count the "PO-B" positions I have for my department and exclude the open ones or if they don't contain "PO-B".
    DATA
    PO-B-1 - Eisenhuth, Rebecca
    PO-B-17 - OPEN
    M-B-1 - O'Banion, Ruth Ann
    QC-B-1 - Thioune, Omar

    Thanks in advance

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

      =SUM(--IFERROR((SEARCH("PO-B",$E$1:$E$28,1)>0),0)*(--ISERROR((SEARCH("OPEN",$E$1:$E$28,1)>0))))

      I hope this will help

  20. Hi Alexander,
    I am not able to formulate given below conditions with IF statements. My query is associated with number of questions, which I need to bind with time. I have no idea how to do formulate with IF conditions.

    Condition-1:
    If I type (greater than 10 questions but less than 16 questions) in 30 minutes then I will be getting 5 marks.

    Condition-2:
    If I type (greater than 5 questions but less than 10 questions) in 20 minutes then I will be getting 3 marks.

    Condition-3:
    If I type (greater than 2 questions but less than 5 questions) in 10 minutes then I will be getting 1 marks.

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

      =IF(AND(OR(A1>10,A1<16),B15,A1<10),B12,A1<5),B1<10),1, 0)))

  21. Hi. I want to tag a certain person as "regular" or "probationary" based on the XX number of their tenure derived from a formula and formatted to " X yr, X mo". My condition is that if the tenure is equal or greater than "0 yr, 6 mo" it should be tagged as regular. My problem is that it returns "probationary" to other values that start with "0 yr" even if the "X mo" is equal or greater than 6 mo.

    Hope you could suggest a better formula. Thank you in advance.

    1. Hello Mods!
      The information presented to you is not enough to give you advice. What format is “X yr, X mo” written in? Text or date? Please specify what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you. Thank you.

  22. a. insert a formula using the IF function that tests whether the age of the invoice is greater than 30.
    b. If the age of the invoice is greater than 30, subtract the due date from the current date.
    c. If the age of the invoice is less than or equal to 30, display 0 to show that the invoice is not overdue.

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

      =IF(TODAY()-A1>30,TODAY()-A1,0)

      I hope it’ll be helpful.

  23. Hi. I am generating a document that:
    A1 B1 C1
    A2 B2 C2
    A3 B3 C3
    A4 B4 C4
    Column A has dates, Column B is auto populated from C1 on the today date, but at the end pf the day C1 resets and on next day B2 gets auto populated.

    Can anyone help?

    1. Hello Aurel!
      I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail.
      What does the phrase e mean "Column B is auto populated from C1 on the today date"?
      Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you. Thank you.

  24. Hi i'm trying to put an IF statement into a cell to show the amount of a transaction under the right category heading. So far I have =IF(D10="Office Equip.",C10,"") so it inputs the value in C10 but I need one IF statement specifically to cover a range of columns from I:AH all with different headings. How would I type this IF formula?

  25. Seeking help of below mentioned conditions.
    If I type greater than 10 but less than 16 questions in Phy/Chem/Maths in 30 minutes then I will be getting 5 points.
    If I type greater than 5 but less than 10 questions in Phy/Chem/Maths in 20 minutes then I will be getting 3 points.
    If I type greater than 2 but less than 5 questions in Phy/Chem/Maths in 10 minutes then I will be getting 0 points.
    If I type greater than 25 but less than 35 questions in Bio/Eng in 1 Hr then I will be getting 5 points.
    If I type greater than 15 but less than 25 questions in Bio/Eng in 1 Hr then I will be getting 3 points.
    If I type greater than 5 but less than 10 questions in Bio/Eng in 1 Hr then I will be getting 1 points.
    Sincere gratitude in advance. Thank You - Amit Sharma

  26. Seeking help of below mentioned conditions.
    If I type >10 but 5 but 2 but 25 but 15 but 5 but <10 questions in Bio/Eng in 1 Hr then I will be getting 1 points.
    Sincere gratitude in advance. Thank You - Amit Sharma

  27. I am not able to figure out while applying multiple If conditions. Seeking you help.

    Conditions-1 :
    If I type >10 but 5 but 2 but 25 but 15 but 5 but <10 questions in Biology/English/ in 1 Hr then I will be getting 1 points.
    Sincere gratitude in advance.
    Thank you
    Amit Sharma

  28. Hello there!
    Here is what I am trying to do:
    If text in Column D (from Workbook 1) matches text in Column E (from Workbook 2) then enter text from Column B (from Workbook 2) in Column F in Workbook 1.
    I cannot figure out how to use the vlookup function for this exercise...
    Help would be very much appreciated... thanks a lot.

    1. Hello!
      In your case, you cannot use the VLOOKUP function. When a search occurs in one data range, and you need to return data from another range, use the INDEX + MATCH functions. Read more about it here.
      If you use Office365, pay attention to the XLOOKUP function

  29. i need a formula that i want to equal first column numbers to second column texts for example firs colum 25 34 56 second column love like hate 25=love 34=like 56=hate and excel learn these equalities and i want to use them after for ex. text sheet 25034 25789 25678 34567 34897 56987 excel and i use left operation and next column 25 25 34 34 56(think that it is a column) and excel write ney column love love love like like hate

    if i use matlab it gets easier or struggle or should i use only excel
    please teach this trick
    (sorry for my bad english)

  30. Good day,

    I need to calculate data into a worksheet from specific Columns on a Mastersheet where it links back to specific Unit (Column B:B), amount of Sessions (Column D:D), but then also just for specific month (Column I:I).

    I could only manage thus far: =SUMIF(Master!B:B,CEN!B6,Master!D:D), but then how do I just get it to consider data for a specific month (Column I:I)?

  31. =IF(B2="",A1,N(A1)+1)
    I am using this formulae, but I didnt understand why series in A showing multiple times
    for B merged cells? How to fix this formulae? I don't want series in A to show multiple times.

    1. Hello!
      I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you. Thank you.

        1. Hello!
          You have 3 options:
          1. Cancel the merging of cells in column B
          2. Merge the cells in column A in the same way as in column B
          3. Remove formulas from cells A83: A88

  32. Dear Alexander.
    You've been more than kind, to help me before, and if it's not too much to ask, I would like to ask for your guidance ones again. I'm having a total of 30 cells (F10, F39, F68, F97, F126 and so forth) that contains the same dropbox of 8 different payment possibilities (PAGO, CARTÃO, CREDITO, DEBITO, DINHEIRO, TRANSFERENCIA, BOLETO, ASSINATURA). I'm trying to generate a formula that shows if one of more of the following 4 payment options (cartão, credito, debito, dinheiro) are listed in one or more of the 30 F-cells. For instance, if F10=BOLETO, F39="", F68=CARTÃO, F97=DINHEIRO, F126=CARTÃO... the formula would generate: "CARTÃO, DINHEIRO". Do you think you can help me with this? Sincere gratitude in advance!! Thank you!! Ronni

    1. Hello Ronni!
      Excel formula cannot work with non-contiguous cells. So you can use something like this formula

      =CONCAT(IF(INDEX(COUNTIF($G$10:$G$40,$H$10:$H$13),1)>0,"debito, ",""), IF(INDEX(COUNTIF($G$10:$G$40,$H$10:$H$13),2)>0,"credito, ",""), IF(INDEX(COUNTIF($G$10:$G$40,$H$10:$H$13),3)>0,"dinheiro, ",""), IF(INDEX(COUNTIF($G$10:$G$40,$H$10:$H$13),4)>0,"cartão",""))

      Where
      formula in G10 is =F10
      formula in G11 is =F39 ....... etc
      in H10 written "debito"
      in H11 written "credito" ... etc

      I hope this will help, otherwise please do not hesitate to contact me anytime.

  33. Hi!

    I need a help with formula: IF A2 is 1, then 1, if A2 is 3 or 2, then 0.

  34. I have data in a 16R x 1C format. As per the formula given by me, only 1 cell will display the value in number based on some calculation and rest of the rows will display "Not Applicable". Cell which shows the number may vary depending upon the inputs, but rest 13 will show "Not Applicable". I want to report the number to another cell, Whether it appears on 1st row, or 2nd row or 12th row etc. only the number must be displayed on the reporting cell. Can you please help me to do the same?

  35. I NEED A FORMULA THAT IF= E:E = COMPLETED, THEN A1-(B1,C1,D1), E:E MEAN WHOLE COLUMN

  36. I would like to build a formula for calculating loan payable. Interest chargeable is 10% of the principal but if no payment is done by 10th of the following month, the interest gets compounded, meaning, interest is calculated on top of the added interest to the principal. Is this doable?

  37. i just want a formula where, there is a number like 364 ,now i want to put formula to find if last 2 digit is square of some number or not , if yes thn give value true(like in this case in 364 -----64 is square of 8) nd if not no thn give value false
    example 2 :- 382 in this 82 is not a square of any number therefore valuse come should be false.

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

      =IF(SQRT(--(RIGHT(A1,2)))/INT(SQRT(--(RIGHT(A1,2))))=1,TRUE,FALSE)

      I hope it’ll be helpful.

  38. I need an equation that does two things. I need it to count a range of cells that has any text value. Also if the count is greater than 5 I need the blank to say "no more off" if the count is less than 5 then cell is blank. This is one of the equations I tried in cell k4 I typed. =count(L6:L22,"*"),IF(k4>5,"no more off","") i tried several different variations of this concept.

  39. Hi, i am trying for if function when the one of cell value is True i need list of drop down values when False it should be Null

  40. sir Please help me to findout the solution IN EXCEL
    if i write AAA1,AAA2....AAA999 and if IT IS MORE THAN AAA999 THEN NEXT VALUE WILL BE AUTOMATICALLY AAB000
    AND THEN AAB000 TO AAB999 AND THEN AACOOO..

  41. Column A = Date 30-June-2020, Column B = Date 30-Sep-2020 (*Overdue morethan 2 months)

    How to condition formatting highlight the cell in Column B in red color

    1. Hello!
      If I understand your task correctly, use this formula in a conditional formatting rule:

      =IF(EDATE(A1,2) < B1,TRUE,FALSE)

      Hope this is what you need.

  42. =if ((a1="g"),1,or(a1="mg"),1,0)
    i want 1 if a1=g and a1=mg also if a1=kg then 0 and so on.

    1. = IF(OR(D32="g",D32="mg"),1,"")

      got it Thanks

  43. Hi Alexander,
    I have a column with some digital values. I am writing an IF statement on the neighbouring column to add paranthesis around the number in the previous column.
    Ex. =IF(D10>0,[D10],0)
    Hoping that if D10 ha a value 5, the IF statement returns [5] adding the square parenthesis. But it does not. How do I fix this? Thanks!

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

      =IF(D10>0,"["&D10&"]",0)

      But at the same time, the number will be converted to text.
      You can also use a custom format without formulas.

      Please go to Format Cells, choose Number -> Custom Format and set

      \[#\];-#,##0;0

      I hope this will help

  44. I need help to excel sheet formats can works auto print with data find as per order...
    Example :
    first name ()
    Second name (). Etc.
    I am working same method in word the mailmerge using for auto data print.
    Give me solution for excel. How can use to autoprint in excel.

  45. Hi sir,
    Please advice me the formula
    I have three ccolumn in excel sheet - Today date ,City and Departure date.for today date i used the formula =today().but i need the formula in departure date i person is coming from same city then today date = departure date and if outside from my city then today date less one day i.e yesterday date

    1. Hello!
      Yesterday's date can be calculated using a simple formula
      =TODAY()-1
      But to give more detailed advice, I do not have the necessary information. Please describe your problem in more detail. Include an example of the source data and the result you want to get. It’ll help me understand your request better and find a solution for you. Thank you.

  46. I have a Date in B6, I want it to show a date in M6 thats 90 days out and if there is words in B6 regarding status "In installation or In permitting" I want it to be blank or show 0. Is that possible?

    1. Hello Charles!
      Do you want the formula, text and date to be in B6 at the same time? It's impossible. If I misunderstood you, explain your problem in more detail.

  47. Hi,
    Please assist as my formula does not seem to be working. It gives wrong answers even for correct checks.
    Formula currently in use: =IF(A2=B2, "Wrongly Charged", "OK")
    The idea is to confirm if NUMBERS in A2 MATCH THOSE IN B2. IF SO THEN ANSWER SHOULD BE "OK"ELSE "WRONGLY CHARGED".
    Formula returns "WRONGLY CHARGED" even for numbers that are the same/equal.

    1. Hello!
      I do not see your data, so I can only guess. Possible reasons why the equality condition for numbers in the IF formula does not work:
      1. Some of the numbers are saved as text. This is indicated by a green triangle in the upper left corner of the cell and left alignment.
      2. Numbers do not match in decimal places, which are hidden by number formatting.

  48. i am calculating the rent payment alert, where in sheet where rent is 2000
    month sr due date due amount paid balance
    1 1-04-2020 2000 1000 1000
    2 1-05-2020 2000 3000 0

    so i need logic for the due amount once the date of due smaller than todays date

    1. Hello!
      I hope you have studied the recommendations in the above tutorial. Please specify what you were trying to find, what formula you used and what problem or error occurred. What do your numbers mean? It’ll help me understand the problem you faced better and help you.

  49. I have 3 columns, one column showing actual costs, one row showing the estimated cost and 3rd column showing my forecasted costs. I want to write an if statement for the forecasted column that will default to the value in the estimated column if our actual costs are zero. However if we do have actual costs I want it to reflect those costs. For example
    Actual Estimated Forecast
    12 5 12
    0 10 10
    3 0 3

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

      =IF(A1=0,B1,A1)

      I hope this will help

  50. I am working on a spreadsheet relating to points (for employees). Each employees late and/or sick is recorded and they are given .5 or 1 point depending on late/sick call. After a year the employees point is removed. To keep the spreadsheet updated, there are formulas in place to change the cell to red once a year has passed. We recently made a change that the employees late will now be removed after 6 months. I need a formula that after 6 months late calls (column E), date is highlighted (column C). For the late point to be removed.
    Columns are as stated below.
    B - Employee ; C - Date ; D - Status ; E - Actual Leave (sick, late etc.) ; F - Points ; G - Total points
    Thank you in advance for your help.

    1. Hello!
      To highlight a cell with a date that happened more than 6 months ago, use the conditional formatting formula

      =EDATE(TODAY(),-6) > C1

      I hope this will help

      1. Thank you for the reply, Alex. I appreciate your guidance.
        This is a running spreadsheet that is tracked daily, with different conditional formatting rules, making it easier for dates to be tracked and points to be removed/added.
        I was hoping there was a formula to only track lates from column E, within a 6 month time frame for dates from column C. Would this need to be an IF formula inputted as a rule?
        I am hoping this makes sense.
        Thanks again for your help.

        1. Hello!
          Your problem is not entirely clear to me. If you want to compare dates with columns C and E, then you can use conditional formatting as a rule

          =EDATE(C1,6) > E1

          This condition is TRUE if between dates C1 and E1 is less than 6 months

          1. Column C are specific dates the employee called in. Column E is what the employee called in (late, sick, FMLA etc.). I need only the lates (from column E), the dates (from column C) within 6 months to be highlighted in order to remove points the employee has accumulated.
            Again, your help is very much appreciated. Thank you for your time.

            1. Hello!
              Each time you describe your problem in a different way.
              What does "I need only the lates (from column E)" mean?
              What do you mean by "lates"?
              What is wrong in the formula
              =EDATE(TODAY(),-6) > C1 ???
              What result do you get? What result would you like to get?
              Do you need dates for the last 6 months (you wrote "within 6 months") or older than 6 months (you wrote "after 6 months")?

              1. I apologize for being so frustrating/confusing. Nothing is wrong with =EDATE(TODAY(),-6) > C1, except it is highlighting ALL dates from column C with 6 months or older. The formula works (and thank you for that), it's just missing one part I need.
                I only need dates highlighted from column C that are labeled "LATE" in column E. Column E has no dates, only words with the type of leave the employee was marked that particular date, e.g LATE, Sick, FMLA(family and medical leave act), LOA(leave of absence), NCNS(no call no show).
                Thank for for your continued help (because clearly I am no excel wizard).

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 :)