IF STATEMENT WITH OR
 

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

IF STATEMENT WITH OR
 

With values in A1 and B1 and formula in C1

=IF(OR(AND(A10,A1<=1001),AND(B10,B1<=3751)),"Rel ease","")

the two conditions listed below

AND(A10,A1<=1001)
AND(B10,B1<=3751)

If this post helps click Yes
---------------
Jacob Skaria


"jojik" wrote:

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

IF STATEMENT WITH OR
 

Hi,

Try this

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

Mike

"jojik" wrote:

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

IF STATEMENT WITH OR
 

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

then copy

On 29 Kwi, 09:09, jojik wrote:
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

IF STATEMENT WITH OR
 

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

"Jarek Kujawa" wrote:

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

then copy

On 29 Kwi, 09:09, jojik wrote:
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

IF STATEMENT WITH OR
 

welcome
thks for the feedback

On 3 Maj, 06:50, jojik wrote:
this is working with me Jarek,
thank you very much..



"Jarek Kujawa" wrote:
=IF(OR(A1<=1001,B1<=3751),"RELEASED","")

then copy

On 29 Kwi, 09:09, jojik wrote:
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- Ukryj cytowany tekst -

- Pokaż cytowany tekst -