I have a workbook that I inherited that includes text in formulas rather than numbers. For example, a formula is:
=If(A1>splitdate,A25*P1_presplit,A25*P1_postsplit)
The split date is a defined future date and P1_presplit and P1_postsplit represent 95% and 5%, respectively
Does anybody know how excel knows what those terms are supposed to represent / how to edit the values that correspond? I assume it might be something on the developer tab but I'm not really sure how to find them
Bookmarks