0.00%

What I am looking to do is display 2 numbers in one cell. Data Example - F80001 = 16 D80001 = 35 Goal for it to look like - 16 / 4.571% / Right now it looks like - 0,016 / 4.571 Here is the formula that I am using =TEXT(F80001,"0,000")&" / "&TEXT(F80001/D80001,"0.00%")*10 Thank you!!!

Hello, For the first time, I am trying to calculate a weighted average. I think I got the weighted average formula correct: =SUM(B20*B25, C20*C25, D20*D25, E20*E25, F20*F25,)/SUM(B25:F25) But we didn't get a score for the cash category, and need the 0% to not be counted. Is there something I...

Hi All, I am trying to create a bar chart with an average line running through. The matrix button works as below:- <tbody> Function % Complete Function 1 54.50% Function 2 40.00% Function 3 34.60% Function 4 33.30% Function 5 23.20% Function 6 21.40% Function 7 20.00%...

Hi All, I have this Google Sheets workbook that is meant to compare sales for the past 4 months. The reports for each month are pulled in automatically from sales force and the 0 values are from the weekends mostly when no sales come in. To compare 4 months on 1 line graph, the lines need to be...

Not sure where to even start on this one - hopefully someone can help direct me. I need to look up a person (i.e. Agent: 63517 Acker, James) then from there, find the section called "Total for xxxx" (i.e. Total for 63517 Acker, James), the find "Available and pull/get the Percent in Adherence...

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

I have a formula that is counting everytime a referenced cell's text appears in another worksheet. It is working perfectly so far for what I need currently. But I want to continue the formula down the column in blank rows so that if I add another team member later, it will still work. When I do...

I am trying to figure out the formula for this and I can't seem to get it done: Everything in Column B must equal the "Completed on Time" in column F Everything in Column C must equal the "Completed on Time" in Column G For example, I need: B2= F10 C2= G10 B3= F3 C3= G3 B4= F6 C4= G6...

Hi, I'm trying to show historical drawn down (not only the max draw down but each time there is a draw down) of return series, and for each of the drawn down to capture # of periods from Peak to Trough and # or periods to recovery. Draw Down is defined as % decline from previous peak. in the...

Trying to take a report that is copied from another program into excel and remove the unneeded data and format it into a usable format. Code Currently using to remove Dates: If Cell Like "Tuesday*" Or Cell Like "Monday*" Like Cell = "Wednesday*" Then Cell.EntireRow.Delete End If It...

Hi, I have a spreadsheet with vast amounts of data. One of the columns will have either 0.00% or a higher positive % value. Where the row contains more than 0.00% in this column I would like the row to be copied into another sheet so that I can do some more formulas on this data. It needs to...