Hi Everyone,
I'm looking for assistance on creating a formula to show a percentage when the goal is zero. If the actual goes above zero than the percentage needs to go lower but if the actual stays at zero than the percentage needs to stay at 100%. Also this is over a 13 week period. (Picture reference below).
I hope this makes sense.
Thank you in advance!
Jenna
I'm looking for assistance on creating a formula to show a percentage when the goal is zero. If the actual goes above zero than the percentage needs to go lower but if the actual stays at zero than the percentage needs to stay at 100%. Also this is over a 13 week period. (Picture reference below).
Owner | Quarterly Goal | Quarterly Total | % of Qtly Goal | Weekly Goal | 4/1/2022 | 3/25/2022 | 3/18/2022 | 3/11/2022 | 3/4/2022 | 2/25/2022 | 2/18/2022 | 2/11/2022 | 2/4/2022 | 1/28/2022 | 1/21/2022 | 1/14/2022 | 01/07/2022 | |
# of Accounts Pending to be Posted | 0 | 20 | #DIV/0! | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 1 | 1 | 2 | 2 | 3 | 5 | 0 |
I hope this makes sense.
Thank you in advance!
Jenna