S
scott
I have an implementation section of a revenue template.
Col B = Currently has the # of months until full utilization ( 7 months
for example)
Col C - has an error check, so that after the VPs make their changes
they are supposed to go back and change the column B value, but they are
not and I am being forced to correct the errors
=IF(OFFSET(B21,0,B21+1)<>100%,"ERROR",IF(OFFSET(B21,0,B21)=100%,"ERROR",""))
Starting in Column D through Column R
are the manually entered percentages of utilziation, i.e.
0%,0%,5%,25%,50%,75%,100% for the remaining columns
I would like the find a formula to tell me how months it takes to get to
100% based in the input data in D through R, but I have not been able to
figure it out.
Thanks in advance.
Scott
Col B = Currently has the # of months until full utilization ( 7 months
for example)
Col C - has an error check, so that after the VPs make their changes
they are supposed to go back and change the column B value, but they are
not and I am being forced to correct the errors
=IF(OFFSET(B21,0,B21+1)<>100%,"ERROR",IF(OFFSET(B21,0,B21)=100%,"ERROR",""))
Starting in Column D through Column R
are the manually entered percentages of utilziation, i.e.
0%,0%,5%,25%,50%,75%,100% for the remaining columns
I would like the find a formula to tell me how months it takes to get to
100% based in the input data in D through R, but I have not been able to
figure it out.
Thanks in advance.
Scott