IF statement between values

[Chris_Grew]

I am trying to work out an IF statement (within one cell) that would reflect

If A2 is less than 0, return 0. If A2 is greater than 100, return 100, if it is in between 0 and 100 then it's A3+A4.

Any help is much appreciated.

Thanks

Chris

 

[jtakw]

Hi,

Write the formula exactly as you described:

=IF(A2<0,0,IF(A2>100,100,A3+A4))

Edit: If the first 2 conditions are inclusive of 0 and 100, use <= and >=

 

[gaz_chops]

Welcome to Mr Excel,

Try

=IF(A2 < 0,0,IF(A2 < =100,A3+A4,100))

 

[Chris_Grew]

Thanks guys, =IF(A2<0,0,IF(A2>100,100,A3+A4)) worked perfectly

 

[jtakw]

You're welcome, welcome to the forum.