Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Percentage Formula Issue
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Formula | Excel Discussion (Misc queries) | |||
Basic Percentage issue: HELP!!! | Excel Worksheet Functions | |||
Percentage Issue | Excel Discussion (Misc queries) | |||
percentage formula | Excel Discussion (Misc queries) | |||
Formula for percentage | Excel Discussion (Misc queries) |