Something to help me keep track of formulas

  • Thread starter Thread starter Phillip Vong
  • Start date Start date
P

Phillip Vong

Is there an Add-In or some third party software that can help me manage my
formulas. They are getting very long and I can not figure out what goes
where. I am looking for something free if possible. THanks.

Here is an example of my formula that's too long.

=IF(A12="Total ",SUM($I$11:$I11),IF(A12="","",IF(ISBLANK('PASTE
ABCone'!F12),IF(((VLOOKUP(A12,'PASTE
ABCone'!$A$11:$I$300,9,FALSE))*(VLOOKUP(A12,'%'!$A$9:$E$505,5,FALSE)))=0,"",ROUND((VLOOKUP(A12,'PASTE
ABCone'!$A$11:$I$300,9,FALSE))*(VLOOKUP(A12,'%'!$A$9:$E$505,5,FALSE)),-1)),IF(((ROUND((VLOOKUP(A12,'PASTE
ABCone'!$A$11:$I$500,9,FALSE))*(VLOOKUP(A12,'%'!$A$9:$E$505,5,FALSE)),-1))-(VLOOKUP(A12,'PASTE
ABCone'!A:F,6,FALSE)))<=0,"",ROUND((VLOOKUP(A12,'PASTE
ABCone'!$A$11:$I$500,9,FALSE))*(VLOOKUP(A12,'%'!$A$9:$E$505,5,FALSE))-(VLOOKUP(A12,'PASTE
ABCone'!A:F,6,FALSE)),-1)))))
 
I don't know of anything like that.

Maybe you could split your formula into separate cells. Then put a nice
description in row 1 and use those helper cells in your final cell.

You could hide those columns so that your workbook still looks the same.
 
Back
Top