Help with correct formula please

[InNeedOfHelpPls]

Thank you in advance for your time. I am relatively inexperienced with excel and am unsure whether what I am trying to achieve is possible. Some assistance would be greatly appreciated. Cheers.

I want a formula that will display a number from 1 through 6 dependant on the value entered into the adjacent cell. Example:

If value of A1 is less than or equal to 42 = display "1" in B1
If value of A1 is greater than 42.01 but less than or equal to 53.6 = display "2" in B1
If value of A1 is greater than 53.6 but less than or equal to 65.2 = display "3" in B1
etc. etc.

Is it possible to put all of the conditions (sorry if incorrect terminology) into the one formula?

 

[Sufiyan97]

Try

=IF(A1<=42,1,IF(A1<=53.6,2,3))

 

[InNeedOfHelpPls]

Try

=IF(A1<=42,1,IF(A1<=53.6,2,3))

Thank you!!!! This worked perfectly.

 

[Sufiyan97]

You're Welcome!

 

[nageswararao]

=if(A1<=42,1,IF(A1<=53.6,2,3))