Data Analysis

[sandipbhatt]

Hi,

I need your help to create a formula for the below idea:-

After applying "IF" function to a column (say Column A), I got values as 1 (for TRUE) and 0 (for FALSE).
E.g.:-

Column A
1
0
0
1
0
1

Now, there are 6 records and out of these records there 3 records with value as 1 and 3 records with value as 0.
So, percentage of records with value 1 is 50% and percentage of records with value 0 is 50%.

My idea is if in "Column A" I change a cell value from 0 to 1 then it would affect the percentage of records with value 1. How to automate this process using a formula instead of changing the cell value from 0 to 1 manually (say if there are 100,000 records) for few records to show that if few records can be changed to TRUE (1) then the percentage would increase.
A kind of macro to create so that if the instruction is to change first 10 records with value as 0 to 1 and get the percentage of records with value as 1. So the macro would look down for values 0 in each cell adn change the first 10 records with value 0 to 1 and give the overall percentage of value as 1.

Please let me nkow if this explaination is not clear.

Thanks,
Sandip

[mikerickson]

No its very clear, but

=AVERAGE(A:A) will return the percentage of TRUE values in column A