Result from writen function doesn't return the correct calculation,

Hi All,

I'm using this function to calculate DSO

Please Login or Register  to view this content.

Now it seems pretty simple to me, but I have a few glitches.

Firstly when the first calculation takes place If the Debt is less then the FS1 then DSOC should be calculated. at Whatever is in DAY1 (which is 30) x the decimal value returned. Instead it just returns 0.

I think this is because of the very last part where it finishes with

Please Login or Register  to view this content.

Logic would tell me that it shouldn't even get to that part as none of the calculations cause it too.

This is my first ever attempt at working with functions, so it's a little confusing for me.

Any help or advise?

I've uploaded a sheet with the details.

Column G has the Function in it.



thanks