Forumals not showing correct result (unless edit and enter)

D

Dannn78

Hi,

Hoping someone could explain and help.

I have a spreasheet with data in 3 colums and i'm try to add a formula but
for some reason everytime i put the formula in b3/b4 and past it down the
rest of the colum it comes up with a "0" zero answer.

B3 - March Actuals - 0
B4 - March Target - (-40500)
B5 - March Variance - (B4-B3) = 40500
B6 - % March - (b3/b4) = 0

If I go in and press F2 and enter on each cell it corrects the formula and
ajdusts it to what it should be. Any suggestions on why this occurs or a
quick way to fix. I actually have 10,000 rows and dont really feel like
pressing F2 enter all day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about copy/paste functions 3
Create error msg based on calculation result in formfield using VBA 0
Create error msg based on calculation result in formfield using VBA 1
Very easy question! (But not sure what to call it - maybe transpos 3
Macro to F2, F9, then cut and paste 1
Fill down function not working correctly and producing weird resul 3
Find row and add variable amount to it 5
Copy and Paste from 1 sheet to another 0

Top