Ozgrid,
My "If" formula if VERY long and I am having to essentially include it twice to make my formula work. Am I missing a simple way to cut it in half or use the "If" function more effeciently? My formula goes: If("very very long formula" is true then, "insert very very long formula all over again here", otherwise false). Other than some VBA - is there a formula like: If("very very long formula" is true then, print the answer, otherwise false).
Thanks for listening,
David