Office 2010 excel

Solved/Closed
john - Dec 21, 2011 at 11:47 PM
 john - Dec 22, 2011 at 05:03 PM
Hello, i am trying to show in cell J2 if the sum of cell I2 is more than 10 to show 10 and if the sum is les than 5 to show 0 have found how to show true false if greater than 5 but not what i need. anyideas would be very helpfull



1 reply

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Dec 22, 2011 at 12:57 AM
use the following formula in J2:

==IF(I2>10,10,IF(I2<5,5,I2))
0
way cool that worked great thank you
0