4872 Shares

Microsoft Excel head scratcher! help me before i go bald?

Microsoft Excel head scratcher! help me before i go bald? Topic: Use case summary example
July 17, 2019 / By Buz
Question: ok..I have created a spreadsheet. I need to work out..B4+.21/35*100 so...b4 cost is 17p and i need to add the value of c4 which in this example is 21p..then...sigh....work out what 65% of that total would be then....add on 17.5% vat to the 65% total price as a selling price. but i want to display the answer in c4. God i am confusing myself here....sorry. In summary, I want to start with a figure add another amount then get a figure of what 65% of that is then calculate adding 17.5% vat to the figure. Thanks in advance ;) this is just an example, there are another maybe, 70 calculations on the page although all the same formula required.
Best Answer

Best Answers: Microsoft Excel head scratcher! help me before i go bald?

Aldrich Aldrich | 8 days ago
I couldn't follow your cell ID's for example I used 100 in A1, 50 in A2, =.65*(A1+A2) in A3 and =.175*A3 in A4 which in your case is C4 i think. 100 fig 1 50 fig 2 97.5 65% of 100+50 17.0625 17.5% of 97.5
👍 244 | 👎 8
Did you like the answer? Microsoft Excel head scratcher! help me before i go bald? Share with your friends

We found more questions related to the topic: Use case summary example


Aldrich Originally Answered: Am gettin bald at 21really am feeling down i cant go without a hut on my head?
Are you male? Well I'm just expecting you are lol so here it goes =) hair loss is typically normal, especially in the fall months.. =) first you must suss out WHY you're loosing hair.. heres the different ways you can loose hair =) 1. Seasonality. You'll lose the most hair in the fall -- typically November and December when hair reaches maturity in its growth cycle. 2. Diet. Hair loss can occur through poor dieting. According to dermatologist George Cotsarelis, M.D., director of the University of Pennsylvania Hair and Scalp Clinic, iron deficiency may be the cause. He states in the April 2006 issue of "Ladies Home Journal," it might be worth checking your levels with your doctor and take a supplement if they're low. 3. Aging. Marc Avram, MD, a Manhattan hair transplantation specialist, told Elle Magazine, "As we get older, follicles shrink, producing skinnier, shorter strands; then the follicles start to die off. That rate and the extent of that process is a matter of genetics." 3. Pregnancy Some women experience hair loss with pregnancy or as part of post-pregnancy hormonal changes. Other women experience hair loss when going on or off (usually off) the birth control pill. 4. Illness or intense stress Sometimes hair loss occurs as a result of illness. Stress, excessive weight loss, iron deficiency and thyroid problems can also cause hair loss. If you're really worried, ask your doctor, however, experts say you really only need to worry if your part is getting wider or you can see your scalp through your hair. For severe cases, you might consult a "trichologist," a physician who specializes in hair loss =) Extra tip: If you're a woman you won't experience male-pattern baldness. Women's hair tends to thin all over. The only FDA-approved hair loss treatment is minoxidil. Minoxidil works in 60-70 percent of cases by improving the follicle's ability to produce hair. You could also have Alopecia which is what my Dad has, he's 45 though lol. But anyone can get it. You can get needles in your head which make your hair grow back =) x x
Aldrich Originally Answered: Am gettin bald at 21really am feeling down i cant go without a hut on my head?
maybe you have a disease..? oh no no.. i hope you don't have any. i comb my hair before i shower... ummm maybe you combing your hair too much? just use any shampoos that controls hair fall. im sorry i don't know the answer but i hope your hair problem last....... good luck to you....

Taletta Taletta
1. Neither team is awarded points, and the team is fined. (if professional) If not professional, both teams will start their next game (not necessarily against each other) but the next game they are scheduled to play, they should start off with a 5:00 penalty. 2. 5 is a common number. like 5, 10, 20, 2, 15.. You know? 7 is just a very odd number and seems random. 5 is more of a "general" number. 3. I don't think this could happen but it would be NO GOAL cause the ref shouldn't have anything to do with a goal (physically) and since the ref was involved in the sequence of the puck bouncing from ref to boards to in the net, it should be no goal. If it was the puck that hit the ref, off the boards, to a player, then in the net, then it's a GOAL cause a player was involved and it was simply either an accident by the ref or a play that he had no control over trying to avoid the puck hitting off of him as he as little time to react. 4. The word kinda annoys me cause its somewhat funny sounding but also can be annoying if repeated a lot and very loud.
👍 100 | 👎 7

Taletta Originally Answered: Microsoft Excel =IF Help?
In cell B4 enter =IF(AND(B1="F",B2=0),10%, IF(OR(B1="F",(AND(B1="M",B2=0))), 5%,0)) all one line In cell B5 enter =B3*(1-B4) format as currency
Taletta Originally Answered: Microsoft Excel =IF Help?
= if(B1=F,(if(B2=0, B3* 0.10, B3*0.05)),(if(B2=0, B3*0.05, B3))) PS: I havent tried it i wrote from your explanation using the logic given in your question if it works happy if not sorry if you face any error let me know will try to help you if i can.

If you have your own answer to the question use case summary example, then you can write your own version, using the form below for an extended answer.