# Posts by nester

• ## Running Percentage With Multiple Criteria

Re: Ongoing Total If Statement

I was able to get the formula to work using the following:

=SUM(C3,E3,G3,I3,K3,M3)/(SUM((SUM(D1:N1)<>"")*(SUM(D3:N3)<>""))*32)

However, if I try to input the correct in later rounds, I get a winning percentage > 100%. I dont want to double count the previous wins. Is there a way to revise?

• ## Running Percentage With Multiple Criteria

I would like to have a running percentage calculated in cell P3 for the attached file. Cells C3, E3, G3, I3, K3, M3 show the number of correct picks. Cells D3, F3, H3, J3, L3, N3 multiply the number of correct picks by a given value in row 1. For each round there are a possible 32 points. I would like to use some sort of IF Statement to have a running winning percentage calculated for each round where points are achieved.

Example:
Round 1 - #picks correct / 32 possible points
Round 2 - # picks correct from Round 1 + # picks correct Round 2 / 64 possible points
Round 3 - so on until round 6 with total picks correct overall / 192 possible points

Any ideas on how to structure an IF Statement?

Thanks, Nester

• ## Determine Difference Between 2 Cells & Return Dependent Value

Re: Plus Or Minus If Statement

That worked perfectly, but you already knew that. thanks.

• ## Determine Difference Between 2 Cells & Return Dependent Value

Hello,

I want to create an IF statement to return the value of the difference between CellB2 - CellA2 if the change is more than +/- 500,000.

• ## Tab Key Spacing

Re: Tab Key Spacing

At first, I thought the file may be corrupt or something. But it happens in both new and old files. weird, man...

• ## Tab Key Spacing

Re: Tab Key Spacing

The sheet is not protected. The tab key will move various numbers of cells for different files.

• ## Tab Key Spacing

When pressing my Tab key while in an Excel spreadsheet, the button no longer moves one space to the right. It moves 10 if pressed once and 19 if pressed twice. Is there a way to reset the Tab key to move one space to the right?

• ## Compare 2 Values & Determine If Outside Of Scope

Re: If Statement Rounding

Word. The second approach worked perfectly. I didnt think of it that way.

Thanks Ger.

-Neezy

• ## Compare 2 Values & Determine If Outside Of Scope

Re: If Statement Rounding

Sorry... they are referencing cells with equations in them. Not cells with hard coded numbers.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]all cells are formatted as currency.

• ## Compare 2 Values & Determine If Outside Of Scope

Re: If Statement Rounding

They are formatted as currency with \$'s

• ## Compare 2 Values & Determine If Outside Of Scope

Hello,

I have two numbers I need to compare using and IF statement. The two numbers are virtually the same, and I want the IF statement to round the numbers so any difference under 100,000 is not detected. For example:

Cell A1 = \$32,194,884.45
Cell B1 = \$32,194,884.37

I would like the statement to look at this number as 32.19 (divided by 1M). I am using the below equation currently, but it is not working:

=IF(ROUND(A1/1000000,1)<>ROUND(B1/1000000,1),"CHECK","0")

• ## Round Off Numbers & Compare

I want to compare 3 columns of data across the same row with an IF statement to verify that all 3 numbers match. I would like the IF statement to only look to the first decimal place, rather than the entire number. In the first example, all columns equal. In the second example all columns equal only to the first decimal place. In either case, all 3 numbers would be equal when rounded down to one decimal place. Any suggestions?

Example 1
Column A Column B Column C
84.5 84.5 84.5

Example 2
Column A Column B Column C
84.51 84.53 84.52

• ## Pivot Table Manual Manipulation

Re: Pivot Table Manual Manipulation

Yep. Some issue with the file. I mad e anew table off of a new data set. Thanks.

• ## Pivot Table Manual Manipulation

Re: Pivot Table Manual Manipulation

I tried that, too. I've tried setting up multiple tables with multiple settings, and the totals are always incorrect.

• ## Pivot Table Manual Manipulation

Re: Pivot Table Manual Manipulation

The file is too large to post. Basically the rows that sum each column do not have the correct amount. I cant manually sum them, bacause it wont let me change that part of the pivot table. Is there a way around this?

• ## Pivot Table Manual Manipulation

My pivot table is not auto summing each column properly, and I can't manually enter a formula to do so. I tried adjusting the settings of the rows and columns through the pivot table wizard, but no luck. Is there a way around this limitation?

Thanks, Nester

• ## Unlock File

Re: Unlock File

I will try that, and attempt to locate a copy file. Thanks.

• ## Unlock File

Re: Unlock File

Correct. I have the password. I try to unprotect the workbook, but I get a prompt saying that the file is locked.

• ## Unlock File

I have a shared file that is now mysteriously locked. How can I unlock the file so changes can be made?

• ## Average By Multiple Columns And Rows

Re: Average By Multiple Columns And Rows

DaveR... that works perfectly! Thank you.