Adjust Percent

Have this solution

then


need get like this

090909090990909090909090909090909909.PNG5653247890344.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
do you mean to populate columns C, D and E using Excel formula?

can you provide logic to calculate the percentage in column C?
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

Thanks for the fast reponse

what i mean is  coumn E is the portion of column D

sets is the percent od total columns
thats the correction needed


rigth now is num percent of count  that wrong
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the corrected formula in the code should be

example row 4   ==   sets 8 / total columns 10 * 100 = 80%

that the correction needed in the code
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
because 8 sets of 10 toral columns  * 100 = 80% for row 4 like example
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ok, for column D: Total Columns, I would apply this formula:

=OFFSET($F$3,0,SUMPRODUCT(MAX((G4:DS4<>"")*COLUMN(G4:DS4)))-6)

Open in new window


then for column E, SETS, I would try this piece of formula:

=COUNTA(G4:DS4)

Open in new window


at last, for column C, % i would simply use column E / Column D

=E4/D4

Open in new window


see if this solved your issue?
5653247890344_b.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
btw, for column C, i just format it instead of multiple it by 100. hence, you can do necessary amendment when necessary.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !
Great Expert !
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

column D  and column E

have the data i alredy need that comes from   V_OUT


but column C is computing alredy % from  column A /B

but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
but whats  I Need is column  E/D

but need that in the code because the code have the worng formula (A/B)

you probably can't save "memory" in the Excel file, so you got to: create another column for the correct percentage formula in case you want to remain the wrong formula in column C (A/B)
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

formula (A/B ) is not needed
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

where in the code can be fixed

E/D is the corrected needed
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
this the file need the correction
65434677665v1--2-_43532.xlsm
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:

E/D is the corrected needed
isn't that in the sample file I uploaded contain the correct formula?

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ryan Chong

you rigth great expert
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.