Hi There,
I am working on my spreadsheet and I suppose I've hit an obstacle...
I've got the following formula, which is giving me strange results...
note: I've added those BreakLines manually to make the code easier to read.
The problem I have is that the formula gives me RANDOM results!
I've pasted the same formula in several cells one below another to show you how different the results are. The formula is exactly the same in every single cell... Please see the picture
I can't seem to understand why is that happening. I can add that I'm running MS Office Excel 2007 and I am regularly downloading updates from windows update.
Do you have any clues as to what might be happening? Urgently need some help, so any assistance would be appreciated!
Kind regards, grandfso
I am working on my spreadsheet and I suppose I've hit an obstacle...
I've got the following formula, which is giving me strange results...
Code:
=IF(ISBLANK(Parametry!C19),0,(Parametry!L45*((INDEX(Dane!$B$5:$N$33,Parametry!C19,12)))))
+IF(ISBLANK(Parametry!D19),0,(Parametry!L46*((INDEX(Dane!$B$5:$N$33,Parametry!D19,12))))
+IF(ISBLANK(Parametry!D19),0,(Parametry!L47*((INDEX(Dane!$B$5:$N$33,Parametry!E19,12))))
+IF(ISBLANK(Parametry!D19),0,(Parametry!L47*((INDEX(Dane!$B$5:$N$33,Parametry!F19,12)))))))
The problem I have is that the formula gives me RANDOM results!
I've pasted the same formula in several cells one below another to show you how different the results are. The formula is exactly the same in every single cell... Please see the picture

I can't seem to understand why is that happening. I can add that I'm running MS Office Excel 2007 and I am regularly downloading updates from windows update.
Do you have any clues as to what might be happening? Urgently need some help, so any assistance would be appreciated!
Kind regards, grandfso
Last edited: