Excel 2007 : Greater than =2, Less than =1

[geofixit]

I need to create a formula that if the value that I enter is less than 15 the number would be "1", but if the value was greater that 15 the number would be "2". can anyone help? I'm just missing something.

thanks

[abousetta]

Hello and welcome to the Forum

Maybe:

Please Login or Register  to view this content.

abousetta

[abousetta]

Another option will be to use Lookup:

Something like:

Please Login or Register  to view this content.

If you have just a few options then I would go with the IF statement. If there are a lot options then I would go with Lookup.

Hope this helps.

abousetta

[geofixit]

wow thanks for the quick reply.
that answered one question, but I realize that what I need is if the value is 0 than the number is 0, if <15 the number is 1, if > than the number is 2.

[geofixit]

solved it with the lookup code!!! thanks

[abousetta]

Hi again,

If statements are easier to comprehend and they can be nested.

For example:

Please Login or Register  to view this content.

and so on... up to 7 nested IF statements.

Lookup gives you a bit more flexibility with larger combinations, but they need to be sorted alpha-numerically.

Hope this helps.

abousetta

[abousetta]

Glad I could be of help. If you are satisfied with the results, then please mark the thread as SOLVED. Also reputation (scales) is always appreciated.

Good luck.

abousetta