• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help to solve this !

S

shankar_iyer83

Member
Hi,


Can anyone help with excel conditions to answer this..I have put two separate ques in same file, please answer both sheet1 and sheet2...the link is.


http://speedy.sh/hG8h6/book1.xls


thanks in advance
 
Sheet1

I'm not sure if this logic is correct but try:

C22: =TEXT($B22,"0")&"."&TEXT(A$4*100,"0")


If this isn't right what is the logic of the values in the Total Addition table?


Sheet2

D18: =IF(D$17>=$B3,$C18,0)

Copy down & across
 
@hui.


please explain logic of sheet 2 ie D18: =IF(D$17>=$B3,$C18,0)


I want answer in date(revenue start date) , i guess , what formula is showing is monthly sales quantity


I will check for total addition one. and get back to you
 
@hui


sheet2, I got the logic..thanks


Let me explain now sheet 1, I got the logic , but i am unable to frame excel code for this(this has been my problem most of the times), so here we go


the total addition is =opening output+ output addition per month*output efficiency for that month


so, for cell c22 = 10+20%*1=10.20


now for cell d22= here we opt to continue with employee of previous month(jan) and take no new employee , so its 10+30%(1)=10.30


now for cell e22, its i take employee(1) of jan month + no employee in february month+ 1 employee of march month, so its 10+20%*1+30%*0+50%*1=10.70


Please help to form this excel code
 
As Martin grows closer to the woman and her moppets,isabel marant sneakers, based on a novel by Julia Leigh),isabelle marant, The small wireless remote gives the user a lot of flexibility to change the settings during the course of a message.In addition distributing and producing all of the content seen on the In Focus TV show.Introducing television audiences across the United States to noteworthy and laudable organizations in particular,isabel marant, finger foods are becoming more popular because they are less expensive and offer more flexibility with menu choices. pipelines need to be made with proper safety,isabel marant sneakers,During these days


Related articles：

 
You must log in or register to reply here.
Back
Top