100.00%

I need a formula that i can place in F:2 that if I:2 equals 100.00% entered Y in F:2 if not enter N I though that maybe something like this would work but is not =IF(EXACT(I2,"100.00%"), "Y", "N")

i have a range(1000 rows) that i want to apply a change to. Its basically taking a variable and placing at the front of each string along with a comma. here is a before and after 6 of 1998 3-0-1 100.00% 14-18-2 43.75% 36, 6 of 1998 3-0-1 100.00% 14-18-2 43.75% variable was 36...

Hello friends! I am relatively new to Pivot Tables, and just learned of DAX yesterday to help me with some analysis I am doing. Now, I have not been able to find this answer for another DAX measure field, and hope that someone will help me with what seems to be an easy question. My source data...

Hi, i have the following: <tbody> Name Pass Rate Previous Score Accumulative Points Accumulative minus Reduction Result Value John 100.00% #DIV/0! 89 89 PASSED 89 Luke 0.00% 0 0 0 FAILED 44 George 100.00% 0 82 82 PASSED 82 Tim 100.00% 0 95 95 PASSED 95 Luke 0.00% 44 0 0 FAILED 63...

Hi, This is my first post. I own a finance company and am trying to determine the % increase / decrease in my fees from year to year. I have this figured out on a month to month basis. However, I am trying to run the month to date average for all the months. The months where no data has yet...

Hi guys, I am having some issues with Index and Match for a project that I am working on. I have a list of employees where I wish to gather data to calculate their targets. Where I get stuck is the source table is not setup the way a typical index table would be. Column A has the employees...

Hi guys, I am having some issues with Index and Match for a project that I am working on. I have a list of employees where I wish to gather data to calculate their targets. Where I get stuck is the source table is not setup the way a typical index table would be. Column A has the employees...

Is it possible to do a conditional format formula that when a percentage in column 1 is greater than the percentage in column 2 that it puts a border line as a divider at the bottom of the section that is above the percentage in column 2 as below? 139.86% 100.00% 131.26% 100.00% 122.96%...

Hi there, Is there any way of selecting a table array based on an identifier (i.e 1). I am trying to perform an index(match) within these tables but I am having trouble in producing an array formula (i.e $A$3:$C$15). My guess is that I should be mapping identifiers (i.e 1,2,3,4,5 etc) to...

Here's a quick example...sorry for the formatting...but I don't have the tools to post html sheets...if someone could point me to what is being used these days i'll add it but essentially i'm trying to figure out if Running Value is top 80% of all values based upon the multiple criteria i...

I have the following table, which shows the approval rate of our deposits for every hour of the day. For example the approval rate at 4 AM was 66.67, but the running average is 58.93% (100+28+50+50+66.67)/5. How do I add this value, which I am showing in a chart, that shows both approved...

HI I'm looking for some help with a rank issue I'm having. I need a formula that will rank based on a criteria (Area) and uses 2 tie breaks. So for example if the are 2 scores of that match in Central England then %1 would determine the highest rank, if the score and %1 match the %2 would...