# Thread: simple formula... (2000 sr-1)

1. ## simple formula... (2000 sr-1)

if I3="no" and J3="no" then "ok" else ""
not work!!!
=SE(I3="NO"+E(SE(J3="NO";"OK";"")))

2. ## Re: simple formula... (2000 sr-1)

E is a function, just like SE. You must use

E(I3="NO",J3="NO")

The total formula becomes

=SE(E(I3="NO",J3="NO"),"OK","")

3. ## Re: simple formula... (2000 sr-1)

Hi Hans

<E is a function, just like SE. You must use>

Out of pure curiosity what are these functions?

Many Thanks

4. ## Re: simple formula... (2000 sr-1)

Sal21 posted a formula from the Italian language version of Excel. E is Italian for AND, and SE is Italian for IF.

5. ## Re: simple formula... (2000 sr-1)

Hi Hans

Now I now why they say curiosity killed the cat!. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Thanks

6. ## Re: simple formula... (2000 sr-1)

Don't worry Braddy, I was wondering too but I was too shy to ask <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

7. ## Re: simple formula... (2000 sr-1)

=SE(E(I3="NO",J3="NO") , "OK","")

I have modified , with ;

8. ## Re: simple formula... (2000 sr-1)

That depends on your system settings - if you use a comma as decimal separator, you must use a semi-colon ; as list separator, and if you use a point as decimal separator, you must use a comma as list separator.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•