| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage with a zero involved
A1 is this month total
B1 is last months total C1 is the difference, =A1-B1 This much I got D1 is the difference in percentage, I use =(A1-B1)/B1 and I get my % in black or (red) which is fine but now the problem There are times we don't always handle a certain item so some months will have a zero in either this month or last months calc and my % is all messed up i get this #DIV/0 I think this means that you can not divide by zero but how do I get around this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting birthdays formatted as month and day (no year involved) | Excel Discussion (Misc queries) | |||
| copy formula with same cells involved | Excel Discussion (Misc queries) | |||
| Determing Len of Numbers with Whole Numbers involved | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Matching when spaces are involved | Excel Worksheet Functions | |||
Threaded Mode
