View original (French)

If function, exclude negative numbers

Solved
V Perfectionnement Posted messages 2 Status Member -  
V Perfectionnement Posted messages 2 Status Member -
Hello,
I have a problem with the IF function. I entered: =IF($N6<1000*($N6>0,1);$N6;0)
I want my result (N6) to display only if it is between 0.1 and 1000. However, it doesn't understand that I don't want to include negative results.
Does anyone have a solution for me?
Thank you very much!
Configuration: Windows XP Internet Explorer 7.0

3 answers

  1.
    Gord21 Posted messages 928 Status Member 289
     
    Good evening,
    You can try: =IF(AND($N6>0.1;$N6<1000);$N6;0)

    --
    Experience: a name that men give to their mistakes.
    Oscar Wilde
    0
    1. V Perfectionnement Posted messages 2 Status Member
       
      WOW! Thank you so much! It works.
      0
  2. Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Hello,

    try this: =IF(AND($N6<1001;$N6>0);$N6;0)
    or
    =IF(AND($N6<1001;$N6>0);$N6;"") if you want your cell to remain empty if the number is not between 0 and 1000. Also, I put <1001 so you can display 1000; if you want to stop at 999, use <1000.

    Have a nice day
    --
    Every problem has a solution... you just need to be persistent.
    0
  3. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Good evening,

    or add some ( ) to your formula:
    =IF(($N6<1000)*($N6>0.1),$N6,0)

    eric
    0