View original (French)

Formula error (Err:511)

pat10 -  
PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   -
Hello,
I created a table with the number of employees distinguishing between part-time and full-time.
I would like it to display 2 if the number of hours is greater than 100, but if it's less than 100, it should display 1, or 0 if there are no hours.
Here's the formula I entered, but I'm getting err:511

=IF(C3>101,2,IF(AND(C3>=0),1,))

Could someone help me?
Thank you for your help

Configuration: Mac OS X (10.10.5) / Chrome 47.0.2526.80

1 answer

  1.
    PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    Good evening

    You need to correct your formula:
    for greater than 100 =2 if you put >101 it will count from 102
    then you say < to 100 but what about the number 100?

    so either it is less than or equal to 100
    formula: =IF(C3=0;"";IF(C3<=100;1;2))

    or it is greater than or equal to 100
    formula: =IF(C3=0;"";IF(C3<100;1;2))

    best regards
    4