Formula doesn't calculate, Excel 2007 bug?

[Okoth]

The formula in cells R7 and S7 don't calculate. When I fill in the numbers in cell J7 and K7 manually it works, but when I use a link to cell T3 and T4 it won't work. Hope someone can help me out.

I have checked the format of the sheet. Doesn't work when all the cells have the same format...
Formula's I am using are not the most difficult ones:

ABS(J7-K7+100)
IF(C7=0;"";SUM.IF($AA$3:$AA$28;N7;$AB$3:$AB$28))
IF(J7>K7;SUM.IF(W:W;L7;X:X);SUM.IF(W:W;L7;Y:Y))
ROUND(1/(MACHT(10;(-W7)/400)+1);3)

Solution must be simple, right? I must be overseeing something.
I am using the Dutch Excel 2007, but I tried it with the English one and it wasn't working either.



In case of, link to the file for 2007 is here: http://leithia.com/ForDoesntWork.xlsx
other: http://leithia.com/ForDoesntWork.xls

 

[pgc01]

Hi Okoth
Welcome to the board

I don't see anything wrong. In R7, since J7>K7 you'll calculate

SUMIF(W:W,L7,X:X)

The value in L7 is 799.9

That number doesn't exist in column W, so the result of the sum is 0.

Please explain.

 

[Okoth]

Wow, that might be it. In my case it doesn't show 799,9 but 800.

Going to look at it now and let you know.

Thanks!
Okoth

 

[pgc01]

In my case it doesn't show 799,9 but 800.

Please notice that it doesn't matter what it shows, what matters is the value.

 

[Okoth]

100% true

 

[Okoth]

Rounded it and it works.

Thanks

 

[mvptomlinson]

Cross-posted at http://www.excelforum.com/excel-general/699092-formula-doesnt-calculate.html

 

[pgc01]

Okoth

Next time write that you have cross-posted and post the respective address(es).

You must realize that if you don't do this there may be people spending time trying to help you when the problem has already been solved elsewhere, which is really disagreable.

 

[Okoth]

I fully agree. Didn't realise it.

I don't make use of forums much, but I'm going to read the rules first next time.

Have been trying to remove my thread from the other website but they have blocked it. Bit too fast.

Thanks