Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Let say that we have 10 Excel cells each one has a number how could we get for example 1250 from the summation of the ten or less cells?

user-image
Question ajoutée par Islam Al-Hemsi , Chief Accountant , Petra Travel & Tourism Co
Date de publication: 2015/06/23
Tahir Nawaz
par Tahir Nawaz , Operations Manager , Askari Bank

125*10  I S A SIMPLE WAY TO GET1250

CHIOMA ANASOH
par CHIOMA ANASOH , PA , Imo State Government FCT

You divide1250 by10 (125) to know the number each cell should have. so ensure each cell has a value of125 to get the summation of1250

KANAKA DURGA BHAVANI PRASAD SURAVARAPU
par KANAKA DURGA BHAVANI PRASAD SURAVARAPU , Vice President – IT & Finance , FIFTH AVENUE GROUP

through if condition if the total of ten cells greater than1250 then display1250 if it is less than1250 then display sum of ten cells.

 

=IF(SUM(G7:G16)>=1250,1250,SUM(G7:G16)) 

Muhammad Mehrban
par Muhammad Mehrban , Teacher (Accounting) , Taiba Higher Scondary School

it can be done in many ways i.e. you can divide the the amount1250 in small amounts in such a way that the total of all these amounts must be equal to1250. 

Atif Tanveer
par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

if each cell has value125 the summation will be1250

More Questions Like This