View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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 -