Office 2010 excel

Solved/Closed
john - 21 Dec 2011 à 23:47
 john - 22 Dec 2011 à 17:03
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

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

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