Smart questions
Smart people
 Find A ForumFind An Expert
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Remember Me

Are you a
Computer / IT professional?
Join Tek-Tips now!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

#### Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

#### Feedback

"...I think this forum rocks it has saved my bacon many many times..."

#### Geography

Where in the world do Tek-Tips members come from?

# syntax

 Forum Search FAQs Links Jobs Whitepapers MVPs
 mistergrady (TechnicalUser) 10 Dec 08 20:02
 I am a novice with spreadsheets. I am trying to write a formula to reflect the following in Open Office:If A1>1 then "Heavy";If A1=0 then "Medium";If A1<1 then "Light"I cannot find the right syntax. Any help appreciated.Thanks.
 feherke (Programmer) 11 Dec 08 3:04
Hi

What you are requesting would be this :

#### CODE

=IF(A1>1,"Heavy",IF(A1=0,"Medium",IF(A1<1,"Light","-")))
But I think your requirement is wrong, because you specify nothing in case A1=1. I think actually you want this :

#### CODE

=IF(A1>0,"Heavy",IF(A1<0,"Light","Medium"))

Feherke.
http://rootshell.be/~feherke/

 mistergrady (TechnicalUser) 11 Dec 08 10:31
 Hello Feherke:As you note, I did not state the case correctly, but I applied your syntax and it worked. Woo Hoo!Thanks for help. I really appreciate it.Regards,grady

#### Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!