• 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.

3 Conditions in a combination of formula

Ajinkya

Member
Hi Friends,


I have been trying to get output as desired, tried maximum function as much as but hv not got exact output,


Please help...sample file is uploaded on following link:


https://docs.google.com/spreadsheet/ccc?key=0ArVSTeTslgqFdDR0NFZvdjB4SXEzWGNzbk01cDhkU1E


i'm trying to get output like column J "Result" and looking for combination of these three conditions into 1 single formula.


Cheers!!!

Ajinkya
 
Hi Koushik,


Inconvenience regretted


https://hotfile.com/dl/164421375/0ac9179/Criteria123_combination.xlsx.html
 
Ok I got the file.


In your entire sheet, it seems like you are doing something like this:


IF models are coming from same region THEN you calculate the cumulative sales of that model ELSE you keep the unique sale vale of that model's entry...same applies for calculatinng cumulative import (col G)....am I correct?


Now I have a couple of questions:


1)What is col J is all about? The reason being, at J3 you have I3 value but the next two cells are filled with 0(all are manual entry)


2)I do not understand the logic of the formula you have K4


Could u plz clarify ur conditions (>,<,=) bit more in detail?


Kaushik
 
Ok I got the file.


In your entire sheet, it seems like you are doing something like this:


IF models are coming from same region THEN you calculate the cumulative sales of that model ELSE you keep the unique sale vale of that model's entry...same applies for calculatinng cumulative import (col G)....am I correct?


Now I have a couple of questions:


1)What is col J is all about? The reason being, at J3 you have I3 value but the next two cells are filled with 0(all are manual entry)


2)I do not understand the logic of the formula you have K4


Could u plz clarify ur conditions (>,<,=) bit more in detail?


Kaushik
 
Hi Koushik,


For Cum. imp and sale you got correct.


now clarification on couple of questions:

would like to clarify by condition to condition


Condition1

If Row 3 and 4 is having same region and model and if sale (H3) is less than import (F3)

then keep the value of H3 in cell J3 and for other rows like J4 and J5 keep "0"


Condition2

If Row 9 and 10 is having same region and model and if sale (H9) is equal to import (F9)

then keep the value of H9 in cell J9 and for other rows like J4 and J5 keep "0"


Condition3

But If Row 15 and 16 is having same region and model and if sale (H15) is more than to import (F15) then keep the value of H15 in cell J15 (3000) and for other rows like cell J16 keep the value of Exceeded Sale ( sale 3001 - Imp 3000 = Exceeded sale 1) and for J17 keep "0"


Hope Koushik, I have tried to clarify......
 
Ajinkya,


Say, for row 3 and Row 4, if I write the formula at M3; combining all your 3 conditions at one place, I will always get H3 value at M3 provided at row 3 and 4 model and region are same. As you said:


... if sale (H3) is less than import (F3)then keep the value of H3 in cell J3

...if sale (H9) is equal to import (F9)then keep the value of H9 in cell J9

...if sale (H15) is more than to import (F15) then keep the value of H15 in cell J15


If we wrcombine all the condition in one place and write the formula, then we will always get the value of "sale" provided model and region are same.


However, at M3 the formula would be: =IF(AND(E3=E4,D3=D4),IF(OR(H3=F3,H3<F3,H3>F3),H3),0)


I am sure you have some different requirement which I am not able to understand.


Kaushik
 
Ajinkya,


Say, for row 3 and Row 4, if I write the formula at M3; combining all your 3 conditions at one place, I will always get H3 value at M3 provided at row 3 and 4 model and region are same. As you said:


... if sale (H3) is less than import (F3)then keep the value of H3 in cell J3

...if sale (H9) is equal to import (F9)then keep the value of H9 in cell J9

...if sale (H15) is more than to import (F15) then keep the value of H15 in cell J15


If we combine all the condition in one place and write the formula, then we will always get the value of "sale" provided model and region are same.


However, at M3 the formula would be: =IF(AND(E3=E4,D3=D4),IF(OR(H3=F3,H3<F3,H3>F3),H3),0)


I am sure you have some different requirement which I am not able to understand.


Kaushik
 
No Problem Koushik,


Minimum you have tried your best !!!


Hello, Yes my friend, can you help me to make it done ...

:)
 
Hi, Ajinkya!


Just passing by, read the topic, didn't understand, read it again, same thing. Could you please elaborate it from a different viewpoint? Try to abstract from cell and row values, and think things as input values, operations on them, and examples of manual output. Thank you.


Regards!
 
Hi, Ajinkya!


As discussed, this could be one way to show this in order to show the actual sales of imported products for same or different regions along with sales indicator.


https://hotfile.com/dl/164619404/425d672/Summary_Result.xlsx.html


Regards,

Kaushik
 
Hi Koushik,


Yup this can be appreciated, thanks dude.


Also as discussed, can we add into something like dynamic look,

adding with first and last date of import, in this we can easily get the period of import and also we can get total days (max-min)


Thanks

Ajinkya
 
<p> </p>


<div class="ProductImage"><img title=" Karen Millen outlet Beaded Dress Grey " alt="Karen Millen outlet Beaded Dress Grey" src="http://www.karen-millen-outlets.co.uk/bmz_cache/a/a37ca7ebcce425fc85c6cee1651d2250.image.128x200.jpg" width="128" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen outlet Beaded Dress Grey</div>


<p> Needless to say, the massive question is, does acupuncture operate And can acupuncture effectively treat asthma Well, not unlike the search for an explanation for how asthma works, the answers usually are not distinct - and so they rely on whom you request. In accordance with conventional acupuncturists, sure, acupuncture for asthma is definitely an successful remedy, particularly with asthma in young youngsters. You'll find many sites and a large number of testimonials that every one attest towards the effectiveness of acupuncture like a therapy for asthma. Acupuncture, they are saying, has worked where nothing else has.</p>


<p>Acupuncture for asthma could <span style="color: #ff6600">Karen Millen Dresses</span>
http://http://www.karen-millen-outlets.co.uk/ audio like an odd mixture. One is a common disease that affects roughly 20 million Americans; the other is really a mysterious, esoteric, alternative medication technique. A lot of men and women have asthma, but not many men and women have attempted acupuncture. But should you be an asthma sufferer, it may appear at instances that something - even some thing as mysterious as acupuncture - is really worth trying. Breathing is some thing that almost all us in no way think of. It really is an unconscious method and unless we're ill, we very easily obtain the oxygen we want. But for people with asthma, breathing is often on their minds. There is certainly constantly the chance that an asthma assault will abandon them gasping for air. Someday these attacks are predictable and often they are not, occasionally they may be minor and very easily dealt with at residence, and sometimes asthma suffers wind up in an unexpected emergency area. It's no ponder that some asthma sufferers have turned to acupuncture for asthma. Asthma is actually a chronic disease with no cure. You can find diverse kinds of asthma, but they all produce the identical indicators and symptoms: rapid breathing, perspiring, fast heartbeat, and also the Karen Millen Dresses unpleasant sensation of suffocation. The exact lead to of asthma is not known (there may be a genetic element at perform), but there is certainly little doubt that environmental aspects - chilly, dust, pollution, etc - trigger the assaults. Throughout the assaults, irritation and constriction from the respiratory passages restrict the level of air that may be inhaled, the assaults can last for minutes or hours and as mentioned before, there is no remedy. Impressive Karen Millen clothing and accessories</p>


<p><br class="Clear" />

</p>

<p> So can acupuncture really aid an individual who suffers from asthma That appears to rely on your perspective. In the event you really feel that sickness is triggered by disruption in energy circulation and you might be convinced by anecdotal studies, the only affordable solution is: attempt it and discover. Acupuncture for asthma is quite safe; severe adverse consequences are extremely uncommon. But in case you are the sort of person who wants evidence inside the traditional sensation, it might make far more perception to stick with the Karen Millen Dresses medications/therapies you're using and await strong evidence that acupuncture can help deal with your asthma.</p>

<p> </p>


<p> Clothes to change to change the fashion. There are always new fashion design and more beautiful than the previous one. Fashion is a static and ground does not change over time. There are many supermarkets and specialty stores, came up with the latest designer clothes for babies and adults. Although this is a well known fact that is specifically for adults, fashion times even a child a better understanding and awareness of the care of his appearance. Borne in mind that demand is growing baby's clothing and accessories, there are many baby boutiques, competing quality accessories and designer some Karen Millen Evening Dresses. Dress a baby girl in the subsequent match of 41 designers to make her look like a angel and given a special kind of happiness and comfort to the parents.</p>



<p> </p>


<p>The store people have been impressed by the baby clothes and accessories. Team of professionals, we provide quality service and baby clothing designer. We are also offering discounts in a variety of products for special occasions. We have different varieties of designer <span style="color: #ff6600">Karen Millen Dresses Outlet</span>. The clothes are soft materials and to help the baby feel very free and comfortable. Online baby stores, home shopping experience.</p>


<div class="BlockContent">

<ul class="ProductList">

<li style="height: 310px">

<div class="ProductImage"><img title=" Karen Millen outlet Broderie and cotton dress white " alt="Karen Millen outlet Broderie and cotton dress white" src="http://www.karen-millen-outlets.co.uk/bmz_cache/1/138948f5a1b9593236a5e66e41728fc3.image.125x200.jpg" width="125" height="200" style="position: relative" /></div>

<div class="ProductDetails">Karen Millen outlet Broderie and cotton dress white
</div>


</div>


<p> </p>


<p> </p>

<p> When we talk about the baby clothes and accessories, it is not limited to a basic skirt or one or two baby accessories, it refers to a range of baby clothes, from the Soil and high fashion skirt girl, baby leg pants variety ofinfants 41, hats and other hair accessories can add to the charm of baby looks. Each baby boutiques, some of the best things available for toddler clothes ... There are two boys and girls. There are many baby clothing style site to help you the latest style and design. Every change in fashion, design or sales offer to appear on the site itself. We can say that relatively more to choose the kind of clothes when it comes to girls than boys. Lovely hair accessories, you can buy them and put it together with their clothes. Parents with additional dress their children's interests in different types of designer clothes to make them look unique and cute than the others. Some of the most popular hair accessories, headgear and talking about it calculates is an important hair accessories baby girl. Whenever a baby wearing a turban, they wear matching look more cute, very cute.</p>

<p> </p>


<p>There are many designer hats, can also be referred to as an attachment, because it is the most common toddler children to wear <span style="color: #ff6600">Karen Millen Dresses Sale</span>. Two hat is designed for boys and girls ... Different brightly colored hat in your toddler's cute. With the onset of winter hat is more demand, because it not only increased the popular, but also help keep your baby warm. Increased demand for many infants have special stores for the customers and discount baby products. I think this is the correct time of year to get some real good baby clothing and accessories for your little ones.But though there is no cure, you can find constant efforts to find new methods of therapy, and you'll find practitioners and individuals who think that acupuncture for asthma is the answer. Acupuncture (the phrase comes from the Latin words acus, meaning needle, and pungere, meaning to puncture) is really an extremely outdated technique of medicine. It's not distinct exactly where acupuncture originates from, but it has become most carefully connected with China. In acupuncture, very narrow needles are inserted in to the epidermis (just hardly penetrating the surface) at certain key points in the entire body. The needles are said to correct a disharmony within the flow of energy via the body, a disharmony that is said to become the cause of illness. Standard, Western medicine has several theories about how acupuncture Karen Millen Dresses works (e.g., it might stimulate the release of all-natural pain relievers, endorphins) but has not but fully explained how acupuncture.</p>


<p> But consult exactly the same question - does acupuncture for asthma function - of doctors and researchers who've been skilled in conventional, Western medication and scientific methodology, as well as the solution will probably be very <span style="color: #ff6600">Karen Millen Dress</span>
http://http://www.karen-millen-outlets.co.uk/http://http://www.karen-millen-outlets.co.uk/ distinct. Acupuncture, they say, is as intriguing phenomenon, however the query of the way it works is less crucial as opposed to question does it function, and their answer to that's no. There is no conclusive evidence that acupuncture for asthma functions, as well as an evaluation from the scientific scientific studies which have attempted to solution this question have not proven acupuncture to be a viable approach for treating asthma. If there are reports that it works, these may be defined by the placebo impact (The placebo impact states that medications or medical techniques/ techniques could be perceived through the affected person as useful due to the fact they think they're successful, but there is no measurable effect).</p>


Related articles:

 
Back
Top