Simple IF

[leebauman]

Hello, I need help with a simple IF statement:

If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2

I appreciate all assistance.

Thanks!

 

[Michael M]

Try

=IF(A2<5,"",IF(A2<10,A2-1),A2+1)

 

[leebauman]

Thank you!