Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Islam Al-Hemsi , Chief Accountant , Petra Travel & Tourism Co
Date Posted: 2015/06/23
Tahir Nawaz
by Tahir Nawaz , Operations Manager , Askari Bank

125*10  I S A SIMPLE WAY TO GET1250

CHIOMA ANASOH
by 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
by 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
by 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
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

if each cell has value125 the summation will be1250

More Questions Like This