60%

Hi, I need help with a formula that is not returning the correct outcome. I work for an awarding body and to pass one of our qualifications you need to achieve a minimum of 60% and at least score a 1 in all 12 questions answered. If you score 60% but score a zero in one question, you are still...

Hi guys, I am running a table to estimate the amount of sales I can generate. <tbody> Jan Feb Mar Apr May June Unit Sold in current month 10 12 14 16 18 20 Unit Sold from previous months X Unit Price ($) 4 4 4 4 4 4 </tbody> The 2nd row is where I am struggling. I am looking...

Hi, I would like to set a formula to return the result as below if the target cell fall to these range. How the formula should set? <colgroup><col></colgroup><tbody> </tbody> <tbody> Point Result 84-84.9 80% 83-83.9 60% 82-82.9 40% </tbody> <tbody> Below 82 0 </tbody>

I am looking for an excel formula to identify the latest stage of a project. <tbody> A B C D E F G H I J 1 Progress Stages 2 Project Prepare Start 30% 60% 90% Complete Stage 3 Battersby 21/09/2018 22/09/2018 15/12/2018 30% 4 Phillips...

This should be easy, but I keep messing it up. The quizzes in a class I'm teaching add up to 60% of the grade. The exam counts for 40 percent. Suggest a formula? Student has a 65 average for the quiz portion, 36 for the exam. Thanks in advance.

Hi everyone :confused: I have a daily report showing some figures this report including one column to calculate the current percentage and there is another column shows the agreed(approved) percentage for every customer "raw". My boss has requested from me to show in my report for those...

Hello Dear, I have used Icon Sets of Conditional Formatting for this range based on the criteria shown in the attached picture, but why 6 is amber while it's 60% and the criterion states >= 60% which should be green, doesn't the 6 equal 60%? (Max=10 and Min=1, 6/10=60%) similarly, while...

Can someone please help me? I wish to calculate the number of occurrences for each trader where the streak of the declared number of trades (I used the variable 5 here) resulted in a winning percentage greater than the hurdle rate (I used 60% here). So for Dan, there was only one time...