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,

Write a formula in exel
How to write & in laptop - Guide
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
How to write e with accent - Guide
Number to words in excel formula - Guide

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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!