LinkBack URL
About LinkBacks
Hi folks,
I am looking for a simple excel formula when the count value is decreasing, the percentage should increase if the sum of count value becomes 0 then it should show as 100%
Hi folks,
I am looking for a simple excel formula when the count value is decreasing, the percentage should increase if the sum of count value becomes 0 then it should show as 100%
Last edited by zigiram18; 06-23-2024 at 10:52 PM.
Welcome to the forum.
Please add your expected results manually - I have no idea what you are expecting from those numbers.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
HI Ali, thanks for your response, I am looking for formula to show percentage based on total count values, please see below example if the count value is become 0 then the percentage comes 100
Pending Account Total Percentage
user1 0 0 0 0 0 100%
user2 12 58 95 65 230
user3 35 65 74 15 189
user4 9 65 65 4 143
That didn't help at all.
What results are you expecting in the cells marked wiuth a question mark?
AliGW on MS365 Beta Channel (Windows 11) 64 bit
user1 user2 user3 user4
Sheet: Sheet1
Hi,
I am expecting 100% based on the total value.
if the total value becomes 0 then the percentage should come as 100%
In F2 copied down;
=IF(F2=0,100%,"")
Format column G as PERCENTAGE.
Why provide a sample set of data where not one row meets the criterion???
Last edited by AliGW; 06-24-2024 at 01:11 AM. Reason: Typo fixed.
HI Ali,
thanks for your supportyou have come closer to my result. if the total value shows 0 then I get 100%, but if the total value is other than 0 can I get percentage of that value?
Maybe like this:
=IF(F2=0,1,F2/SUM($F$2:$F$5))
See post #4. What results would you expect for those values? I have no idea what the maximum value is, so it's impossible to work out the percentage range.
You are not helping me to understand.
Try:
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks