Hello,
I have a report (attached) that I would like to write a formula, vba, or condition......... in column J ("CPB" tab) that would automatically enter a value of 100% if it is empty.
Currently, I have manually entered the 100% (in gray font) - attached is an example.
I appreciate your help and time!
Kind Regards,
Paula
Your example is not clear so
Try this in J8 then fill down =IFERROR($D8/SUM($D$14:$D$15),1)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Solution with macro, press button 100%.
Please explain what 'it is empty' means, in particular what is 'it'?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you so so so much for your help and time; Both of these options work great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks