Can I please have the formula for: if a range is less than a number (in a different cell) then 0. If the range is greater than the number then take the amount greater than the number.
Thank you
Excel 2007
Excel Workbook
C 15 =IF(sum($B$1:G1)<=100,0,IF(sum($B$1:G1)>100,sum($B$1:G1)-100,"")) Sheet1
copy in G2 and drag across