| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is my formula is not calculating, it works in other areas?
I use a simple formula: =(b1/a1)-1 to calculate percentage difference. It
normally works just fine, but for some reason is not working now. It works in my other spreadsheets and even in other areas of the same sheet. I have tried re-entering it rather than copying it but still no luck. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why is my formula is not calculating, it works in other areas?
Try clearing cell content and reenter the formula. There maybe be somthing
there that is causing the problem. "sandarm" wrote: I use a simple formula: =(b1/a1)-1 to calculate percentage difference. It normally works just fine, but for some reason is not working now. It works in my other spreadsheets and even in other areas of the same sheet. I have tried re-entering it rather than copying it but still no luck. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula for Calculating a Floating Date | Excel Worksheet Functions | |||
| I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
| Calculating and locking the esult of a formula | Excel Discussion (Misc queries) | |||
Linear Mode
