Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |