Darlene Bost wrote:
> There must be a macro that can do most of this quickly as opposed to the
Sorry I can't attempt to help much with the first part of your question.
Unfortunately, I'm not much of a macro guru with the current versions of
Excel. Hopefully, someone else can help
> (therefore 0 closed). If I use c5/b5 it says #DIV/0!. I really need for
> the months with no issues due to be 100%.
try @if(b5=0,100,c5/b5)...might have to modifiy it a little depending on
how you have formatted the target cell.
Loy
-----
**Need help with PCSOFT mailing list? Send an Email to:**
Bob Wright<[log in to unmask]> or Drew Dunn<[log in to unmask]>
|