Ubuntu
openoffice.org package

nesting if statements

Asked by Ron

I would like to be able to do the following
if cell 1< 249 cell 2 = 5, if cell1 < 499, cell 2 = 4; if cell 1 < 999 cell 2 = 3

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Rich Johnson (nixternal) said : 		#1

=IF(A1<249;5;IF(A1<499;4;IF(A1<999;2)))

Revision history for this message
Rich Johnson (nixternal) said : 		#2

Hello, did this do what you wanted? If so, may I please ask if you could close the ticket? Thank you very much, and I sure do hope this was what you were looking for.

Revision history for this message
Ron (rhitchcock-ibew) said : 		#3

Richard Johnson wrote:
> Support request #2362 on Ubuntu changed:
> https://launchpad.net/distros/ubuntu/+ticket/2362
>
> Comment:
> Hello, did this do what you wanted? If so, may I please ask if you could close the ticket? Thank you very much, and I sure do hope this was what you were looking for.
>
>
 Yes it worked. Thank you very much.

--

Clarence Darrow:
With all their faults, trade unions have done more for humanity than any other organization of men that ever existed. They have done more for decency, for honesty, for education, for the betterment of the race, for the developing of character in men, than any other association of men.

Can you help with this problem?

Provide an answer of your own, or ask Ron for more information if necessary.

To post a message you must log in.