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 124. Total comments: 4573

  1. I am working on the calculations of moon on excel,,I have download spreadsheets but they use macros,,,can you plz tell me that how can I extract real formulae from the codes???

  2. I need to find the exact data for using index and indirect formula

    A 50
    a 40
    B 30
    b 20

    Using Index and match funtion could you help me

    =MATCH(F$39,INDIRECT("'"&$A$1&"'!A"&F$41&":IV"&F$41&""),0)
    getting Error (#Name?)

    =INDEX(INDIRECT("'"&$A$1&"'!A"&$F$41&":Z"&$F$42&""),MATCH(F$39,TRUE,EXACT(INDIRECT("'"&$A$1&"'!"&F$41&":IV"&F$41&""),0)))
    Ref error

  3. It is exactly working in the same way I want.

    I am really sorry for too many basic questions...I am just trying to learn excel.

    with the above formula, I am getting the output in the way I want..but need a small extension to it.

    Say for example I have this formula in “AA” for SL (sick leave) and “AB” for VL (Vacation leave) “AC” for CF (Compoff)

    Now as per your formula when I give SL it is getting reduced but if I give VL it is not working.

    Also if I enter CF in the default 0 value it should increase the count, for example if enter CF anywhere from A1 to Z1 the count should get increased in “AC”

    1. Subbu,

      I am sorry, not sure that I can follow you. If you can post this question on our forum and attach a sample workbook for better understanding, our support team will try to help.

  4. =IF(OR(A1="A"), 20-COUNTA(A1:F1),"20") this worked well for a single cell.

    Now I want to use the same formula reflecting on multiple cells like:

    Targeted cells that I want the result is in from A1 to Z1 and I applied my formula on AA cell

    Now whenever I enter a value “A” in the cells anywhere from A1 – Z1 the count in the AA cell should get reduced.

    AA = contains my actual leaves per year
    A1-A20 contains the team member names
    A1 to Z1 cells contains the number of days in a month

    If anybody is on leave on that particular day, the count in the AA should get reduced.

    1. Got it :)

      In this case, you need a different formula, like this:

      =IF(COUNTIF(A1:Z1, "A")>0, 20-COUNTA(A1:F1), 20)

      The COUNTIF function counts the number of "A" in cells A1:Z1, and if it's greater than 0 (i.e. if there is at least one "A"), the count will be reduced.

  5. It is working for one cell that is A1. What if i want to apply the same formula from A1:Z1.

    I tried but it is giving an error

    please help

    1. Do you want to copy the formula to other cells? If so, you will need to use absolute or mixed cell references depending on your data structure. To be able to advise something more concrete, I need to know the exact formula you are using and what exactly result you expect it to return in other cells.

  6. sorry for coming back again...

    But in this formula no matter wheather i give "A" or "B" the count is getting reduced.

    =IF(OR(A1="A", A1="B"), 20-COUNTA(B1:F1), "A")

    i want the count to be reduced only if i give "A"...please help...

    1. Subbu,

      Yes, the formula reduces the count if A1 is filled with either"A" or "B" because that was the requirement: "if the empty cell is filled with “A” or “B” it should reduce the count".

      If you want the count to be reduced only if you input "A" in A1, then remove the OR statement from the logical test:

      =IF(A1="A", 20-COUNTA(B1:F1), "")

  7. It worked well thanks again

  8. That was a very speedy reply.. Your are great…appreciate it and thanks you very much for your help.

  9. it is a very small doubt..

    I am using this formula as below and want to add an “IF clause” to it saying that only if the empty cell is filled with “A” or “B” it should reduce the count...how can I get it...please help

    =20-COUNTA(C5:AF5)

    ignore the above post.....

    1. Assuming that the empty cell is A1, you can use the following formula:

      =IF(OR(A1="A", A1="B"), 20-COUNTA(C5:AF5), "")

      Instead of "" you can supply any value you want the formula to return if A1 is neither A nor B.

  10. it is a very small doubt..

    I am using this formula and want to add an IF to it saying that only if the empty cell is filled with A it should reduce the count...how can i do it...

    1. Hi Subbu,

      It could be something like this:

      =IF(A1="A", value_if_true, value_if_false)

  11. Hi

    Just wondering whether the following can be shortened
    i.e. if B58 shows either TX or SR it will generate
    6% in cell C58

    =IF(B58="TX",6%,IF(B58="SR",6%,))

    Thanks

    1. Hi!

      You can use the OR statement like this:

      =IF(OR(B58="TX", B58="SR"), 6%,)

      1. Thank you so much

  12. Hi

    Need an help in writing formula for attendance time tracking

    If the In Time is 09:00 and Out time is 17:30 - PRESENT
    If the In Time is 10:30 and Out time is 17:30 - HALF DAY
    If the In Time is 09:00 and Out Time is 15:00 - HALF DAY
    If the In Time is 09:10 - LATE
    If absent - ABSENT
    If Sick Leave - SL
    IF Comp Off- COFF

  13. I am trying to devise a spreadsheet to calculate wages using IF formula - can you help? If I enter house worked in column A. I want to calculate daily pay based on first 8 hours at one rate and anything above that at a higher rate. Thanks

  14. Can get help writing a formula that:

    if the number in cell F8 ends in .5 then G8 is $1.00
    if the number in cell F8 ends in .25 then G8 is $2.00
    if the number in cell f8 ends in 1 then G8 is 0
    if the cell f8 is left blank then G8 is 0

    This is an order form. For further clarification: if a customer orders a whole box (1) there is no charge. If they order a 1/2 box (.5) there is a split free of $1.00 for us to split the box. If they order a 1/4 box (.25), there is a $2.00 split fee. I need that cell to recognize that an order of 1.5 will need the $1.00 charge. Does that make sense? Help!

  15. Hi, I was wondering if you could help me on this.

    example:

    If A1 and B1 both equal 2, then say yes, elso say no.

    Thanks :)

    1. Nvm, I got it, I was reading your blog and found it, thanks :)

  16. I have also tried the following formula. But no matter if I get a number less than 60 I am still getting a "D" when i should be getting a "C","B","A".
    =IF(E20>100,"F",IF(E20<100,"D",IF(E20<80,"C",IF(E20<60,"B",IF(E20<40,"A")))))

    1. Hi Jessica,

      Because you put E20<100 before others "less than" conditions, Excel checks it first and if the condition is met it simply does not evaluate any other logical tests. And because any value that is less than 40 is definitely less than 100, your formula returns "D".

      As soon as you change the order of IF's, everything works as it should :)

      =IF(E20<40,"A",IF(E20<60,"B",IF(E20<80,"C",IF(E20<100,"D", "F"))))

  17. Please help :)
    I am trying to do multiple IF functions so i can get different grades according to a score. Can you please check my formula and tell me what am I doing wrong ? I have tried using the AND and the OR but it is not working. I think it could be the comas and parenthesis but i am not sure.

    Thank you,

    =IF(SUM(E11,E20)>100, "F",IF(OR(E20<80, "D"),IF(OR(E20<60,"C"),IF(OR(E20<40,"B"),IF( OR(E20<20, "A"))))))

  18. Hi

    I need to combine the following two IF Statements into one, I am thinking of using the OR function along it

    Function 1
    =IF(Q4="E",IF(T4>=12%,IF(T4<=19.99%,"0.5%",IF(T4<=24.99%,"1%",IF(T430%,"3%",0)))),"0%"))

    Function 2
    =IF(Q4="N", IF(T4>=10%,IF(T4<=19.99%,"1.25%",IF(T4<=24.99%,"1.75%",IF(T430%,"3.75%",0)))),"0%"))

    I tried using the IF OR function but got stuck.

    Any help would be appreciated combining the two functions into one

    1. Some help would be appreciated on this

  19. Please solve it

    I want to put up two conditions.

    Value - 1 :225
    Value - 2 :0.075%
    if ((225*0.075%=0.05,"Actual Value")).

    if the product of the both value is greater then 0.05 then i want the actual value means the product of the both value.
    Is it possible and if possible please explain.

    1. Hi Ankit,

      If my understanding of your task is correct, the following formula should work a treat:

      =IF(A1*B1>0.05, A1*B1, "")

      If the product of values in cells A1 and B1 is greater than 0.05, it returns that product, an empty string otherwise.

  20. Hi Svetlana,
    I need help with this formula:
    Quantity B1=500
    Frequency B2=4
    Cost B3=1000
    Shipment# B5="Shipment# 1"

    COGS B4=(B1*B3)/(12/B2) and then spread that B4 into the next 3 columns because (12/B2=3)

    The Quantity, Frequency, Cost will change so i need to write a formula for COGS B4 to capture this change. For example:
    Quantity B1=600
    Frequency B2=3
    Cost B3=500

    COGS B4=(B1*B3)/(12/B2) and then spread that B4 into the next 4 columns because (12/B2=4)

    I also need to write another formula to spread these info to the next columns. For example, if Frequency B2=3, then 4 months later in column F1=600, F2=3, F3=500,F5="Shipment# 2" and so on..

    Thank you for your help!

  21. Hi Svetlana, you're right the IFs are driving me crazy :s
    I can't seem to figure out what I'm doing wrong.

    I have a sheet that contains owner name, product name, number of products.
    I want to create a formula where I calculate the amount of products per owner.

    For example
    A: Pete - B: Apples - C: 40
    A: Steve - B: Lemons - C: 20
    A: Pete - B Apples - C: 30

    Pete is listed under the product "Apple" twice and in total he bought 70 apples. How do I calculate that number?

    I have tried the following:
    =IF((AND(A:A="Pete",B:B="Apples")),C:C)

    What I'm trying to say here is IF column A contains the name Pete AND column B contains the product Apples, THAN all the values in column C that contain the conditions from column A and B should be added up.

    I think I'm close with my formula but I can't seem to figure it out. Could you help me and let me know what I'm doing wrong?

    PS: sorry if I'm posting this multiple times but something seems to be going wrong when I press the send button.

    1. Hi Rachel,

      Excel has special functions SUMIF and SUMIFS to add up values based on one or several conditions, respectively. And they make things really easy :)

      Since you have 2 criteria, the SUMIFS function is the right choice:

      =SUMIFS(C2:C100, A2:A100, "pete", B2:B100, "apples")

      You can find the detailed explanation of the SUMIFS arguments in this tutorial:
      https://www.ablebits.com/office-addins-blog/excel-sumifs-multiple-criteria/

      PS No worries about the duplicate post, I've deleted it.

  22. Hey Svetlana,
    Can you please tell me if we can apply condition if formula in multiple cell at one time.

  23. THANKS

  24. Please advice the formula for the following condition
    1 ) If staff has taken leaves between 0 – 7 days will get 3 day paid leave rest all deduction
    2) If staff has taken leaves between 8 – 14 days will get 2 day paid leave rest all deduction
    3) If staff has taken leaves between 15 – 20 days will get 1 day paid leave rest all deduction
    4) more than 20 days 0 paid leave

  25. Hi Svetlana - i have read through all the posts as best i can. I'm sorry if you've answered this already:

    I have two cells (A1 and B1) that have numbers in them. Sometimes A1 is blank. When there are numbers in both, i want C1 to bring them together with a dash.

    For instance, if A1=3 and B1=4 then C1 should say "3-4".

    If A1=(blank) and B1=4 then C1 should say "4".

    Here is the forumula i'm trying to use:

    =If(A1>0,A1&'-'&B1,B1)

    However, excel does not recognize cell B1 in the formula.

    Thanks!

    1. Sorry - i was using the wrong "quotes" in the formula.

      1. Spot on :) Your formula with double quotes works perfectly!

  26. I am trying to produce a working formula for a sum-if-or statement and can't come up with something that works.
    I have numbers to sum in columns E11-E47. If Column G11-G47 shows a "T" or "S", I would like those numbers correlating in E11-E47 to sum, but if G11-G47 shows an "R" then the value in G11-G47 should result a 0.

    Make sense?

    I have =SUM(IF(OR(G11:G47="S",G11:G47="T"),E11:E47,0)) but it's not working properly and summing all of the values in E11-E47.

    Thanks!

    1. Hi Becky,

      Excel has special functions to conditionally sum cells, SUMIF and SUMIFS. In your case, you can use 2 SUMIF functions to sum values in cells E11:E47 if column G has either "T" or "S" in the same row. And then, add up the results returned by both SUMIF's:

      =SUMIF(G11:G47, "t", E11:E47) + SUMIF(G11:G47, "s", E11:E47)

      You can find more details and more formula examples in the following tutorials:

      SUMIF in Excel - formula examples to conditionally sum cells

      How to use Excel SUMIFS and SUMIF with multiple criteria

  27. IF(A1>=100, 100, IF(A1>49, A1, IF(A1>25, 100-A1, IF(AND(A1>0, A1<26), A1+50, ""))))

  28. Hello, I am trying to categorized a list of text values and created the following formula but it is not working, the search and if formulas can not be nested?

    =IF(SEARCH("License",$A11,1)>1,"License", IF(SEARCH("SnS",$A11,1)>1,"SnS", IF(SEARCH("Consulting",$A11,1)>1, "PSO", IF(SEARCH("Training",$A11,1)>1, "PSO","CHECK"))))

    Thanks

  29. I am trying to come up with a formula for the following,
    If H3, I3, M3 or N3>1,"Pass","Fails"
    this works for one cell or any array but not different cells. New to Excel formulas so any help would be appreciated. Thanks!

    1. Hi Michelle,

      Just use the following OR statement:

      =IF(OR(H3>1, I3>1, M3>1, N3>1),"Pass","Fails")

      1. When I write it like this it will show a pass for the column when all are above 1 but when the cell shows a 1 it will not prompt a Fail it only continues to prompt pass. What am I doing wrong?

        1. Will it matter if I have other formulas populated in the cells that are in this formula?

          1. Michelle,

            This should not really matter. If you can send your sample worksheet along with the expected results to our support team (support@ablebits.com) I think we will figure it out faster.

            1. Hi! Can u help me please..
              I would like to enter a value in any cell from a1 to d1 then it will display the same value in cell e1. What is the formula i should write? Thanks

            2. telle me formula

              Excel - If "pass","fail" - How do I set the formula

  30. hey, i'm trying to come up with a function to display Yes if value is more than 22.41 for female athlete OR if it is more than 22.47 for male athlete: if not it should display No.

    1. Hi Dee,

      Asumming that you have values in column A and male/female in column B, you can use the following formula:

      =IF(OR(AND(A2>22.41, B2="female"), AND(A2>22.47, B2="male")),"yes", "no")

  31. Hi,
    Am trying to do the following:
    If G16 >=1 and G16=1, G16<=3),OR(C4="NA")),"", "Low") but it does not work.

    Any help much appreciated.

    1. Hi Stuart,

      You probably mean:
      =IF(OR(AND(G16 >=1, G16<=3), C4="NA"), "", "Low")

  32. Hi! Trying to do the following:

    If G30 is greater than or equal to 100 but less than or equal to 106.99, multiply G25 by 2
    If G30 is greater than or equal to 107 but less than or equal to 118.99, multiple G25 by 3.5
    If G30 is greater than or equal to 119, multiple G25 by 5

    Any help is appreciated!

    1. Hi!

      Here you are:
      =IF(G30>=119, G25*5, IF(G30>=107, G25*3.5, IF(G30>=100, G25*2, "")))

  33. first of all ,thanks in advance for the people whom create these very nice tutorials.I wanted to do math operation on the results of nested IFs.how could it possible with one formula??? my formula is as this:
    =IF(HOUR(D26)>0; HOUR(D26)*45357; IF(MINUTE(D26)>0; MINUTE(D26)*755.95; IF(SECOND(D26)>0; SECOND(D26)*12.6;0)))
    ---------I wana add a statement to above formula in order to sum the true values , it calculate the first but ignores others!!!! I wanna sum hour+minute+second

  34. I'm trying to return different values, based on multiple ranges of cells.
    e.g.
    if any cell in the range a1:a4 contains a number value, then true=1,false=""
    and if any cell in the range a5:a9 contains a number value, then true=2,false=""
    and if any cell in the range a10:a20 contains a number value, then true=3,false=""
    etc.

    Have tried several formulas and keep getting error message.

    Are you able to help me with this?

  35. Hi! I am working in excel and need help with an IF formula for the following statements:

    If the cell value is =8 then 30 points are awarded
    If the cell value is >=10 then 60 points are awarded
    If the cell value is >16 then 30 points are awarded
    If the cell value is >17.5 then 0 points are awarded

    This IF statement is meant to calculate whether our wholesaler is stocking the appropriate # of days of inventory. If they stock 8-10 days of inventory they are awarded the maximum points. They are penalized for dipping below or above the targeted range per the schedule above.

    Any help you can provide would be greatly appreciated!

    1. Hi Kristen,

      Here you go:
      =IF(A2>17.5, 0, IF(A2>16, 30, IF(A2>=10, 60, IF(A2>=8, 30, ""))))

      Please note that I use >=8 in the last logical test, because =8 would return nothing for 9 days. Anyway, you can always adjust the conditions the way you want :)

      1. Good Day,
        Can you kindly help me with the following.
        I want to use a function for the following.
        There are codes which starts at 1000-000 till 7400-000, what I want to do is that if a certain code is typed in, there must automatically display 15 or 0 in another column in which I'm typing in the function, 15 if true 0 if false.
        Kind Regards,

      2. Thank you!!!

  36. =IF(F14=D14,C14,IF(F14=0.7,C15, IF(F14=0.72, C16, IF(F14=0.74,C17, IF(F14=0.76, C18, IF(F14=0.78, C19, IF(F14=0.8, C20, IF(F14=0.7, C21, IF(F14=0.84, C22, IF(F14=0.86, C23,IF(F14=0.88, C24, IF(F14=0.9 ,C25, 0)))))))))))).. I TYPE THIS FORMUALLA MANUAL. IS THERE ANY OPTIONS TO DO SHRT WITHOUT TYPING THE NEXT CONSECUTIVE CELLS.

  37. HI!
    I am working on a spreadsheet to keep track of real estate commissions and need a formula to help me. I thought it was the if function, but it does not seem to be working.

    I need it to do:

    If C3="yes" and D3>500000 then K3= H3*.5 or if C3="yes" and D3<500000 then K3= H3*4

    Any help would be great!

    Thanks,
    Mel

    1. Hi Mel,

      Try this one:

      =IF(AND(C3="yes", D3>500000), H3*0.5, IF(AND(C3="yes", D3<500000), H3*4, ""))

      1. Hi Mam.. i have a doubt in excel
        If column A equals to column c then substract column b and colum d...
        Pls tell me how can i do in excel

  38. Hi,
    I'm hoping someone can help me.
    I have a spreadsheet that I enter X into a cell when a student has completed a task. If they completed four tasks (four X's) the are finished. I'm trying to do a formula that will count the X's for a specific row and if it is 4 or more it will put a "C" in another cell or better yet it will put a "C" and also colour the cell. Is this possible??
    Thanks!!

  39. Hi, I have a question.
    I want a formula to the following:

    If column S2=N return the sum of Q2*G2 or if S2=Y return the sum of R2*G2

    1. Hi SandeeBee,

      Here you go:

      =IF(S2="N", Q2+G2, IF(S2="Y", R2+G2, ""))

      1. Thanks you Sandeebee for asking this question.
        And thank you very much Svetlana for your response.
        You both have really help me solved an issue i have been dealing with here.
        Thank you.

  40. Hi Erin,

    Try the following formula for English scores:
    =IF(AND(C2>D2,C2>39),"pass",IF(D2>39,"pass","fail"))

    And if it works as you expected, make a similar one for Math.

    1. Svetlana,
      That's great! Thank you! Is there a way, perhaps, to join both the english and the math? for example, if english is a passing grade and math is a passing grade, they pass the course. if english is a passing grade but math is a failing grade, they fail the course...? If both grades are passing, they pass, but if one or both grades are failing, they fail the course. Is there a way to put this into one formula, or should I calculate the english separately and the math separately and then create a formula from those?

      1. Erin,

        Of course, there is a way:

        =IF(AND(OR(C2>39, D2>39), OR(E2>37, F2>37)), "pass","fail")

        The formula works with the following logic:
        If either column C (english) or D (english retake) is above 39 AND either E (math) or F (math retake) is above 37, it returns "pass", "fail" otherwise.

        My first suggestion was excessively complicated in fact, and there is a more elegant solution for individual subjects, e.g. =IF(OR(C2>39, D2>39),"pass", "fail")

        1. Thank you so very much! This is MUCH appreciated!

  41. Thanks for the awesome website!
    I am trying to compile some data and was wondering if there was a way to do this?
    I have a list of test scores in column C (english) and E (math). In column D english retake) and E (math retake), I have a list of retake scores for those tests. Some of those scores will be blank because some students did not retake a test.
    I need to see who passes and who fails based on taking the highest score for each section. Basically, a student passes if english is above 39 and math is above 37. If one is less, they fail. I can figure a formula for this. However, I need to take into consideration the retake scores. If a retake score is higher than the original score, I need excel to take that number. If the retake score is lower or blank, that number can be ignored. Is this possible?
    Thanks so much!

  42. Thank you Svetlana, you are truly amazing!

  43. HI, I could really use some help making an if/then equation:

    -If Z2 equals 0, then "4"
    -If Z2 equals 1, and Y2 > 0, then "3"
    -If Z2 equals 1, and Y2 = 0, and U2 > 0, then "2"
    -If Z2 equals 1, and Y2 = 0, and U2 = 0, then "1".

    Thanks!

    1. Hi Courtney,

      You can try the following nested IFs:

      =IF(Z2=0, 4, IF(AND(Z2=1, Y2>0), 3, IF(AND(Z2=1, Y2=0, U2>0), 2, IF(AND(Z2=1, Y2=0, U2=0), 1, ""))))

  44. Hi Svetlana,

    I wondered if you could help me with the following problem!

    I have a spreadsheet which shows expenditure, restricted funds and designated funds.

    If the expenditure is greater than the restricted funds, and the restricted funds fall below zero, I want to use the designated funds instead.

    So if expenditure minus restricted funds is less than zero, use the number in the designated column and subtract the difference.

    I hope that makes sense! Sorry if I'm not explaining it very well! Any help is much appreciated.

    Thanks
    Ciara

    1. Hi Ciara,

      Yep, it makes a perfect sense except exactly what difference to subtract:

      >use the number in the designated column and subtract the difference.

      Also, please specify the column letters for expenditure, restricted funds and designated funds.

      1. Hi Svetlana thanks so much for your help

        Column letters
        Expenditure E
        Restricted F
        Designated G

        Thanks!

        1. Ciara,

          Also, please clarify about the difference:

          >use the number in the designated column and subtract the difference.

          The difference between which numbers shall we subtract?

  45. Hi,

    I need some help creating a formula please. I need to create a formula based on the amount of trucks that passes a certain point. The formula should be based on the following :

    1 - 25 trucks = 50 + that figure
    26 - 49 trucks = 100 - that figure
    50 - 99 trucks that figure
    100+ trucks = 100

    Can anyone please assist?

    1. Hi Juan,

      Supposing that "that figure" means the number of trucks and it is in cell A1, you can use the following formula:

      =IF(A1>=100, 100, IF(A1>49, A1, IF(A1>25, 100-A1, IF(AND(A1>0, A1<26), A1+50, ""))))

  46. i would like crate formula for if time crossed more than 16:00:00 if after 4:00 Pm of an activity using if function the text should say " Activity delayed", " Actvity on time"...

    Please create a form for the same

    MM Rajesh

    1. Hello Rajesh,

      You can do this with the following formula:

      =IF($A1>TIMEVALUE("4:00:00 PM"), "Activity delayed", "Actvity on time")

  47. Hi,

    I hope that this does not confuse anyone and I will attempt to explain what I am trying to do as best as I can.

    I currently have the following formula located in cell P6:

    =IF(O6-TODAY()>0,O6-TODAY(),0)

    This is essentially a countdown cell that stops when the date that appears in cell O6 equals Zero days remaining.

    My question relates to attempting to hide the initial Zero that appears in cell P6 without turning the font white and having to use conditional formatting. I am hopeful that there is a way to write the formula so that cell P6 is blank until a date is entered in O6, then, when the date is entered and the countdown reaches Zero, that Zero remains showing.

    Thanks,

    Dan

    1. Hi Dan,

      Your explanation is perfect :) Hopefully, this is what you are looking for:

      =IF(O6-TODAY()>0, O6-TODAY(), IF(O6<>"", 0, ""))

  48. I would like to create a formula that says if a1*.8>10000, return 10000 and if a1*.8<10000, return the value of a1*.8. Can you help??

    1. Hello Brandy,

      =IF(A1*.8>10000, 10000, A1*.8)

      Please pay attention that the formula will also return a1*.8 if a1*.8=10000

  49. I am trying to complete a payroll workbook. Sheet 1 is the summary page with columns reading "Hours Worked", "Overtime", "PTO", etc. When I enter in an employees time on their individual timesheet I would like the column for "Hours Worked" to cap at 80 and reflect the Overtime on it's own. I have the Overtime showing on it's but I can't find the formula to cap the hours worked at 80. Hope this makes sense.. :( Please help!

  50. want calculate the count of students have 60 and above, 65 and above and 70 and above in their Subject 1 and subject 2 both. Having trouble as i need to do this for 2000+ students. Please help

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