J
Josh O.
I am trying to get a formula to calculate Volume and Issue number for me
based on a number of contracted Issues.
The formula that I have right now is as follows
=IF(E94>0,100*(INT(E94/100)+INT((H94+MOD(E94,100))/2))+MOD(H94+MOD(E94,100),2)," ")
This formula does what I want it to, except when a contract starts with
Issue 2 of a particular year.
I have the a number format ("Vol. "####" Iss. "####) to display the number
as Vol. and Issue (i.e. Vol. 6 Iss. 02).
If I enter in the other fields - "starting issue" Vol. 6 Iss. 01, with 2
issues contracted, I get Vol. 7 Iss. 01, which is correct (there are only 2
issues per year). But if I enter Vol. 6 Iss. 02, with 2 issues contracted,
the result is Vol. 8 Iss. 0. I need the result to be Vol. 7 Iss. 02.
Any suggestions?
based on a number of contracted Issues.
The formula that I have right now is as follows
=IF(E94>0,100*(INT(E94/100)+INT((H94+MOD(E94,100))/2))+MOD(H94+MOD(E94,100),2)," ")
This formula does what I want it to, except when a contract starts with
Issue 2 of a particular year.
I have the a number format ("Vol. "####" Iss. "####) to display the number
as Vol. and Issue (i.e. Vol. 6 Iss. 02).
If I enter in the other fields - "starting issue" Vol. 6 Iss. 01, with 2
issues contracted, I get Vol. 7 Iss. 01, which is correct (there are only 2
issues per year). But if I enter Vol. 6 Iss. 02, with 2 issues contracted,
the result is Vol. 8 Iss. 0. I need the result to be Vol. 7 Iss. 02.
Any suggestions?