Previous Topic Next Topic

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



Related:

1 response

Answer 1 / 1
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
john
Dec 22, 2011 at 05:03 PM
way cool that worked great thank you
0