Write a formula in exel [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,





I am trying to write a formula - If the sum of a group of cells is more than 8 then the balance needs to be in a specified cell.

Please help,
thanks,

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
In the specified cell put
=8-sum(a2:a8)
mention your range in place of a2:a8