Previous Topic Next Topic

Write a formula in exel

Closed
von - Jun 20, 2011 at 11:57 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 21, 2011 at 05:11 AM
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 response

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response