Office 2010 excel [Solved/Closed]

Report
-
 john -
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

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
use the following formula in J2:

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!