Good morning!
I ran into an interesting issue yesterday. A formula that has worked correctly since it was written by a predecessor 2 years ago gave a very unexpected result. Formula is is follows;
=(IF(A256="Andersen 200",Windows!C9,IF(A256="Andersen 400",Windows!C15,IF(A256="JW Builders Vinyl w/J Chnl",Windows!C23,IF(A256="JW Brickmould Vinyl w/J Chnl",Windows!C28,IF(A256="JW Flat Casing w/J Chnl",Windows!C33,IF(A256="Paradigm",Windows!C38,IF(A256="Paradigm Triple",Windows!C43,IF(A256="Paradigm Flat Casing",Windows!C48, 0))))))))&IF(A256="MasterView Vinyl", Windows!C53, IF(A256="MasterView Vinyl Flat Casing",Windows!C60,IF(A256="Mathew Bros Vinyl",Windows!C67,IF(A256="Mathew Bros Vinyl Flat Casing",Windows!C73, 0)))))*1

Apparently the fellow who wrote the formula ran into the nested IF limit and had to add to the formula using the &. Yesterday I had to select the Anderson 400 and instead of seeing a cost of $183 as expected I saw $1830. I checked a couple of things, evaluated the formula and it was $183 all the way until the very last step. Then it changed to $1830. Hmmm... I changed the "&" to "+" and now all is well. Thought it might save someone else some time in the future.
Thanks,
Bill