Same formula giving different results in different cells

grandfso

New Member
Joined
Sep 16, 2008
Messages
10
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...

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)))))))
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
 
Last edited:

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
you might have a circular reference in there somewhere. circular references tend to skew results. Also have you tried breaking down the formula to see where the problem is?
 
Upvote 0
Hi Swinglow,

I think I've had some mess with the brackets...
Anyways I've converted the formula to
Code:
=SUM(
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!E19),0,(Parametry!L47*((INDEX(Dane!$B$5:$N$33,Parametry!E19,12))))),
IF(ISBLANK(Parametry!F19),0,(Parametry!L48*((INDEX(Dane!$B$5:$N$33,Parametry!F19,12))))))

and now the results are more constant... thanks for quick reply!

Kind regards, grandfso
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top