Homer35805
09-02-2014, 07:14 AM
ALCON,
First thing I want to say is that I did not write this formula, but the person who did has departed to greener pastures without leaving any information at all on some of his, extremely complicated (well they look complicated) formulas that I now must maintain. Here is the formula
=IF(I63="Non-Leap Year",TEXT(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!A4:M34,MATCH(TEXT(NOW(),"MMM"),'%'!A3:M3,0),FALSE),"##.0%")&" or "&TEXT(B45*
(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!A4:N34,MATCH(TEXT(NOW(),"MMM"),'%'!A3:N3,0),FALSE))/1000000,"#,###,####.0")&"M",TEXT(VLOOKUP("Day "&
TEXT(DAY(NOW()),"##"),'%'!P4:AC34,MATCH(TEXT(NOW(),"MMM"),'%'!P3:AC3,0),FALSE),"##.0%")&" or "&TEXT(B45*(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!
P4:AC34,MATCH(TEXT(NOW(),"MMM"),'%'!P3:AC3,0),FALSE))/1000000,"#,###,####.0")&"M")
Yes, before you ask, one formula in one cell(currently resides in cell I64). The first thing I would like to do is figure out what he is/was trying to do here and can it be done easier? Secondly, can this formula be written in a more understandable way? Which I guess ties into the first question, but man, I saw this and my jaw dropped, literally....
So, any and all assistance is gratefully accepted.
Thank you to any who might respond, because at this moment, I am lost in the wilderness of this particular Excel formula. :banghead: :crying: :help
First thing I want to say is that I did not write this formula, but the person who did has departed to greener pastures without leaving any information at all on some of his, extremely complicated (well they look complicated) formulas that I now must maintain. Here is the formula
=IF(I63="Non-Leap Year",TEXT(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!A4:M34,MATCH(TEXT(NOW(),"MMM"),'%'!A3:M3,0),FALSE),"##.0%")&" or "&TEXT(B45*
(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!A4:N34,MATCH(TEXT(NOW(),"MMM"),'%'!A3:N3,0),FALSE))/1000000,"#,###,####.0")&"M",TEXT(VLOOKUP("Day "&
TEXT(DAY(NOW()),"##"),'%'!P4:AC34,MATCH(TEXT(NOW(),"MMM"),'%'!P3:AC3,0),FALSE),"##.0%")&" or "&TEXT(B45*(VLOOKUP("Day "&TEXT(DAY(NOW()),"##"),'%'!
P4:AC34,MATCH(TEXT(NOW(),"MMM"),'%'!P3:AC3,0),FALSE))/1000000,"#,###,####.0")&"M")
Yes, before you ask, one formula in one cell(currently resides in cell I64). The first thing I would like to do is figure out what he is/was trying to do here and can it be done easier? Secondly, can this formula be written in a more understandable way? Which I guess ties into the first question, but man, I saw this and my jaw dropped, literally....
So, any and all assistance is gratefully accepted.
Thank you to any who might respond, because at this moment, I am lost in the wilderness of this particular Excel formula. :banghead: :crying: :help