IF STATEMENT WITH OR

[jojik]

Hello friends,
I have 1 spreadsheet showing the following data:
A B C
UP(INR) UP(USD) CODE
1000 3750 ??

I need to get the CODE as 'RELEASED' if col A is <=1001 or col B is <=3751.
Actually either col A or col B will be filled one time.
thankyou very much in advance...
joji

 

[Jacob Skaria]

With values in A1 and B1 and formula in C1

=IF(OR(AND(A1>0,A1<=1001),AND(B1>0,B1<=3751)),"Release","")

the two conditions listed below

AND(A1>0,A1<=1001)
AND(B1>0,B1<=3751)

If this post helps click Yes

 

[Mike H]

Hi,

Try this

=IF(OR(AND(A2<>"",A2<=1001),AND(B2<>"",B2<=3751)),"Released","")

Mike

 

[Jarek Kujawa]

=IF(OR(A1<=1001,B1<=3751),"RELEASED","")

then copy

 

[jojik]

this is working with me Jarek,
thank you very much..

 

[Jarek Kujawa]

welcome
thks for the feedback

this is working with me Jarek,
thank you very much..







- Pokaż cytowany tekst -