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?
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
Re: Plus Or Minus If Statement
That worked perfectly, but you already knew that. thanks.
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.
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...
Re: Tab Key Spacing
The sheet is not protected. The tab key will move various numbers of cells for different files.
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?
Re: If Statement Rounding
Word. The second approach worked perfectly. I didnt think of it that way.
Thanks Ger.
-Neezy
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.
Re: If Statement Rounding
They are formatted as currency with $'s
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")
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
Re: Pivot Table Manual Manipulation
Yep. Some issue with the file. I mad e anew table off of a new data set. Thanks.
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.
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?
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
Re: Unlock File
I will try that, and attempt to locate a copy file. Thanks.
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.
I have a shared file that is now mysteriously locked. How can I unlock the file so changes can be made?
Re: Average By Multiple Columns And Rows
DaveR... that works perfectly! Thank you.
