=IF(ROUND((((B6-B5) /B5) * 100), 0) < 0, "0%", ROUND((((B6-B5) /B5) * 100),
0) & " %")

August B5 = 0 0% (Because there is no July entry)
September B6 = 1 100%
October B7 = 0 0% (Because we are not in October yet)

I want to show the % Increase

Hi John :)

I was able to accomplish what you are trying to do:

Try using this formula:
=IF(MONTH(1&A5) MONTH(TODAY()), 0, IF(B4<1,B5-B4/1,B5-B4/B4))

Here's how I have the spreadsheet set up:

In rows A5 through A16, I have the month names,
A5: January
A6: Februrary
A7: March
Etc...

In Rows B5 Through B16, I have the change per month:
B5: 0
B6: 1
B7: 0
Etc...

In rows C5 through C16, I have the formula I posted above:
=IF(MONTH(1&A5) MONTH(TODAY()), 0, IF(B4<1,B5-B4/1,B5-B4/B4))

Result: If the monthly bucket you're in is GREATER than the current month,
it will always display 0% until you enter that month. It will show a
negative change if you've gone from 1 to 0 ... which it should, because in
that case you've gone from a 100% change to a -100% change. If you go from 0
to 1, it will show a 100% change.

Note: You do not need to multiply by 100, and you do not need to add a %
sign into the equation. Just right click on the column you want percentages
in, and click on "Format Cells...", from there on the "Numbers" tab, click on
"Percentages". You can pick whether or not you want to show any numbers
after the decimal place.

This will automatically convert any numbers in that row from 1 to 100%, etc.

Let me know if you have any questions, I really think this will solve your
problem.

Final Result:
A5: January B5: 0 C5: 0%
A6: February B6: 1 C6: 100%
A7: March B7: 1 C7: 0% [<- note, this is 0% because there is
no change]
A8: April B8: 0 C8: 0%
....

If this is NOT what you were attempting to do, please explain your problem
again. But I do believe this will solve your issue.

Best of Luck! Feel free to let me know if you have any more questions :)
--
Chris VN

Drive your career--master Excel.


"John Barr" wrote:

=IF(ROUND((((B6-B5) /B5) * 100), 0) < 0, "0%", ROUND((((B6-B5) /B5) * 100),
0) & " %")

August B5 = 0 0% (Because there is no July entry)
September B6 = 1 100%
October B7 = 0 0% (Because we are not in October yet)

I want to show the % Increase