Formula error (Err:511)
pat10
-
PapyLuc51 Posted messages 4566 Registration date Status Membre Last intervention -
PapyLuc51 Posted messages 4566 Registration date Status Membre 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
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 réponse
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
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