 # Formula not working

• Hi:

My spreadsheet is giving me fits. I am using this formula:

=IF(DG5=0,0,IF(EZ5=0,0,DG5/EZ5))

I copied it from the cell to the left and the formula is correct. My problem is, it gives me the wrong answer. It gives me the same answer as the cell to the left. It's like it isn't even calculating the formula. This is true for three cells in a row.

Does this make sense? Any ideas? Thanks!!

• Re: Formula not working

Do you have automatic calcualtion switch on?

• Re: Formula not working

What are the values in DG5 and EZ5? What value does that formula return? What value do you want it to return?

• Re: Formula not working

Yes, Auto Calc is on.

DG5 = 254595
EZ = 533354

The answer I'm getting right now is 0
But when I copy the formula from the cell to the left, I get the same answer as the cell to the left. It's like it isn't calculating.

Thanks for any ideas!

• Re: Formula not working

Check format of your cell and change to General
If you are draggin to the left the cell will change to DF5 and EY5.
What's the values in those cells?

• Re: Formula not working

Quote from Robert Mika;681978

Check format of your cell and change to General
If you are draggin to the left the cell will change to DF5 and EY5.
What's the values in those cells?

I changed the format but nothing happened, except that the figure doesn't show up as a % anymore.

I actually was dragging the cell from the left and the formulas update fine. It's just that they do not calculate a result.

I even retyped in the formula from scratch and that's when I get zero, or actually a blank cell.

• Re: Formula not working

silly question, and might not help, but have you tried stepping into the formula to see what excel says is happening as each if is evaluated? Probably not an issue since the formula looks good, but without it being a format issue just wasn't sure...

• Re: Formula not working

Quote from Rowddawg;681985

silly question, and might not help, but have you tried stepping into the formula to see what excel says is happening as each if is evaluated? Probably not an issue since the formula looks good, but without it being a format issue just wasn't sure...

I actually did not try that but i will. Thanks

• Re: Formula not working

If you can attached your wrkbook that would be handy.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!