View original (French)

IF and OR functions in Open Office Calc

Solved
marchaiseng Posted messages 172 Status Member -  
Alyann3 Posted messages 7 Registration date   Status Member Last intervention   -
Hello,

I wanted to create a condition but I'm having trouble.
I wanted to set if A4 is less than 50 then C4 equals 4 or if 50<A4<70 C4= 5 otherwise C4= 6

In short, if A4 = 30 then C4 = 4
A4=2.5 then C4 = 4
A4= 50.5 then C4= 5
A4 = 1000000 then C4 = 6

I hope you understand
Thank you in advance.
Configuration: Windows XP Firefox 2.0.0.20

7 answers

  1.
    UsulArrakis Posted messages 7683 Status Contributor 3 196
     
    Hi
    a priori
    Put in C4 =IF(A4<50,4,IF(AND(A4>=50,A4<1000000),5,6))
    --

    (_Usul of Arrakis
        Serial_Dreamer_)
    4