75%

Hello, can you please help point me in the right direction on this formula. Basically it has 3 conditions depending on day count. If <60 it should return “80%” If >60 but under 180 it should return 75% And if over 180 it should return 65% I am trying this but it wont work...

This table has some data from an analysis of the game of tennis. Row 4 shows the names assigned to each column. Columns D & E are assigned the names PGS_A & PGS_B, which stands for the probability of Player A/B returning a groundstroke. Column F (NumTrials) shows the number of trials...

Hi, Is it possible to calculate averages on a userform with TextBoxes/Comboboxes? Example: Combobox1.additem = "50%" combobox2.additem = "100%" Maybe...? Lol Textbox1.value = combobox1.average + combobox2.average Visually it would say within Textbox1 75% So, before I hit submit on the...

Trying to use VLOOKUP to pull data from 2 or multiplearrays. Only kicker is that I use multiple “Y’s” throughout each tableand “Y” is the value I use to lookup the correlating data. Is this possible? <colgroup><col width="68" style="width: 51pt;" span="11"> <tbody> TABLE 1 TABLE...

<colgroup><col width="64" style="width: 48pt;" span="5"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="64" style="width: 48pt;" span="5"> <tbody> Trying to use VLOOKUP to pull data from 2 or multiplearrays. Only kicker is that I usemultiple...

Hello, Trying to sort my data as follows: Sorting is based on the Color, for this example White >75% first, when all White >75% are gone then sort for all Blue >75%, When all blue are gone sort for all Red >75%. If no Color is >75% then sort using the color that has the greater %. In cell B211 I...

OK I am having trouble with an IF LOOKUP formula SHEET 1 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q 1 2 #000000[/URL] "]Product #000000[/URL] "]Lot #000000[/URL] "]Subdivision Stage #000000[/URL] "]Classification #000000[/URL] "]Quality #000000[/URL] "]Type...

Hello everyone I have a table, I need a formula that look thru this table and if the number does not fall within this table than do additional formula otherwise display results. for example I have table like this: 128 - 132 = 50% 144 - 148 = 75% 160 - 164 = 100% In this case if the data equal...

I have a large data dump of 1200+ students and all their test scores. What I want to do is output a results (true/false) for each agent that had at least 2 consecutive test scores above 75% Example ID | Name | Test Score 123456 | Student A | 76% 654321 | Student B | 86% 435261 |...

Hi, I am trying to create a sheet for training programmes, whereby I can select the training parameters i.e. set x reps etc. from a dropdown say 4x8. This then updates the training programme from the parameter set out on another existing sheet. So sheet 1 might look like this, with different...

Hello all, Hope you are doing well, Can anyone assist me in correcting the formula which lacks a function/condition to suffice my project. Assume the below cell values information provided: · B9 = Receipt amount · I9 = Level of Graduation · M9 = Grade Achieved ·...

I am new to VBA and currently have the following one set-up: Private Sub Workbook_Open() MsgBox "Notify Customer 90 days prior to deadline" MsgBox "Notify Customer when travel has exceeded 75%" End Sub However, the notifications pops every time I open the worksheet and that is not too...