Hello all, in Excel2010, when i drag a formula down the column, the result returned in all the cells is the same as the top cell even though the formula is correct in the filled cells. If i type the formula in each cell then i get the correct result. Any assistance would be appreciated.
Hi and welcome to the forum
I suggest that you upload a sample spreadsheet so we could figure our a solution for you.
To upload a file click on Go Advanced on the bottom of your screen, then click on paperclip icon and Add Files.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here is the sample file. I'm trying to divide column E by column D. Thanks
First go to Excel Options, Formulas and change Calculations options from Manual to Automatic.
Use formula to hide errors
=IFERROR(E2/D2,"")
Thank you so much for the assistance.
You're welcome and thanks for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks