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
|