| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
