Formula I can't figure out

[dpgreen]

I know this is a strange request and it maybe difficult to do withou
seeing the whole spreadsheet but I am fairly new to excel and I can'
make heads or tails of a formula in a vital spreadsheet that has decide
to stop working. The spreadsheet was created by my predecessor and
can't figure out any of it. I mean I literally don't use the vas
majority of functions in this formula so I have no idea what they do
Here is the formula (if this request is crazy without being able t
upload the original document then feel free to delete it moderators)

=IF('Index Data'!B7>'Char
Data'!$C$56,IF(INDIRECT(Correlations!$C$1&Correlations!Z2&'Char
Data'!$C$2)="",(PRODUCT(INDIRECT('Chart Data'!EW2&'Inde
Data'!B7):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2-1))^(1/((DAYS360('Index Data'!B8,'Manage
Data'!$B$1)-30)/360)))-1,(PRODUCT(INDIRECT('Chart Data'!EW2&'Inde
Data'!B7):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2))^(1/(DAYS360('Index Data'!B8,'Manage
Data'!$B$1)/360)))-1),IF(INDIRECT(Correlations!$C$2&Correlations!Z2&'Char
Data'!$C$2)="",(PRODUCT(INDIRECT('Chart Data'!EW2&'Char
Data'!$C$56):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2-1))^(1/((DAYS360('Chart Data'!$B$56,'Manage
Data'!$B$1)-30)/360))-1),(PRODUCT(INDIRECT('Chart Data'!EW2&'Char
Data'!$C$56):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2))^(1/(DAYS360('Chart Data'!$B$56,'Manage
Data'!$B$1)/360))-1)))


Thanks,

Da

 

[Spencer101]

I know this is a strange request and it maybe difficult to do withou
seeing the whole spreadsheet but I am fairly new to excel and I can'
make heads or tails of a formula in a vital spreadsheet that has decide
to stop working. The spreadsheet was created by my predecessor and
can't figure out any of it. I mean I literally don't use the vas
majority of functions in this formula so I have no idea what they do
Here is the formula (if this request is crazy without being able t
upload the original document then feel free to delete it moderators)

=IF('Index Data'!B7>'Char
Data'!$C$56,IF(INDIRECT(Correlations!$C$1&Correlations!Z2&'Char
Data'!$C$2)="",(PRODUCT(INDIRECT('Chart Data'!EW2&'Inde
Data'!B7):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2-1))^(1/((DAYS360('Index Data'!B8,'Manage
Data'!$B$1)-30)/360)))-1,(PRODUCT(INDIRECT('Chart Data'!EW2&'Inde
Data'!B7):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2))^(1/(DAYS360('Index Data'!B8,'Manage
Data'!$B$1)/360)))-1),IF(INDIRECT(Correlations!$C$2&Correlations!Z2&'Char
Data'!$C$2)="",(PRODUCT(INDIRECT('Chart Data'!EW2&'Char
Data'!$C$56):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2-1))^(1/((DAYS360('Chart Data'!$B$56,'Manage
Data'!$B$1)-30)/360))-1),(PRODUCT(INDIRECT('Chart Data'!EW2&'Char
Data'!$C$56):INDIRECT('Chart Data'!EW2&'Char
Data'!$C$2))^(1/(DAYS360('Chart Data'!$B$56,'Manage
Data'!$B$1)/360))-1)))


Thanks,

Dan

When you say this spreadsheet has decided to stop working, do you mea
just this formula or the whole thing?

Are there any specific error message? Whether these are pop ups o
errors showing within cells

 

[dpgreen]

When you say this spreadsheet has decided to stop working, do you mea
just this formula or the whole thing?

Are there any specific error message? Whether these are pop ups o
errors showing within cells.

Hi Spencer,

Sorry for taking so long to get back to you, i figured it out - th
formula is working fine as it turns out - the issue was with the impu
values that the formula references, once i corrected those, it worke
perfectly.

Thanks,

Da