If Statement Help Please!!!!

[vwachieve]

I haven't used 'IF' statements too much, and I'm uncertain that I should be using this function for my challenge, but I thought it was a good place to start.

Here's my issue:

I thought using an 'IF' statement would be what's needed to determine the following:

Based on # of weeks

If # of weeks is more than 13, then result is max of 13
If # of weeks is less than 1, then result is 0
If # of weeks is less than 13, but more than 0, then result is equal to # of weeks.

What's the best formula to use in this case?

VW

 

[Legacy 51064]

Based on # of weeks

If # of weeks is more than 13, then result is max of 13
If # of weeks is less than 1, then result is 0
If # of weeks is less than 13, but more than 0, then result is equal to # of weeks.

What do you mean by max of 13?

=if(A1>13,13,if(A1<1,0,A1))

 

[vwachieve]

Max of 13 means, the number can not exceed 13, even if # of weeks is greater than 13.

 

[Legacy 51064]

What result do you want if the weeks equals 13?

 

[vwachieve]

13

 

[Legacy 51064]

This should work:

=if(A1>13,13,if(A1<1,0,A1))

 

[vwachieve]

Thank you very much!

 

[Gerald Higgins]

Or slightly simpler . . .

=if(a1>13,13,max(a1,0))