syntax 1

[mistergrady]

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]

Hi

What you are requesting would be this :

=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 :

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

Feherke.

http://rootshell.be/~feherke/

 

[mistergrady]

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