ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula doesn't copy correctly (https://www.excelbanter.com/excel-worksheet-functions/239473-formula-doesnt-copy-correctly.html)

sara

Formula doesn't copy correctly
 
When I use autofill, the formula doesn't copy correctly. I don't get an
error, yet it doesn't display the results. In the cells I autofill, I get the
following: $ -
Why is this? How come the autofill displays this?

Luke M

Formula doesn't copy correctly
 
Example of your formula please?

With the limited info given, a random guess is that the cells you are
filling to are formatted to accounting, and the result of formula is 0.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"sara" wrote:

When I use autofill, the formula doesn't copy correctly. I don't get an
error, yet it doesn't display the results. In the cells I autofill, I get the
following: $ -
Why is this? How come the autofill displays this?



All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com