Using the IF Function within Excel

[LiamHems]

I am trying to work out a calculation within Excel and my values for 'arg' can lie anywhere between -10 and +10. Within a cell, I would like to work out how to use the IF Function to say:
If the value of 'arg' is greater than +1, then the value will be changed to +1. If the value is less than -1, then the value will be changed to -1 and if the value lies between -1 and +1, then the value would stay as the same

I hope this makes sense and some one can help me out with this query. Thank you very much!

 

[pjmorris]

try this:

=MAX(-1,MIN(A1,1))

or

=IF(A1>1,1, IF(A1<-1,-1,A1))

where A1 is 'arg'

HTH

 

[LiamHems]

try this:

=MAX(-1,MIN(A1,1))

or

=IF(A1>1,1, IF(A1<-1,-1,A1))

where A1 is 'arg'

HTH

Thank you very much! The second line works for me!

 

[pjmorris]

delighted it works, if the second works then the first should work just as well