Hi,
I need assistance obtaining one formula providing a result in column D on my attached example based on the following criterias:
• If a "Var" (column B) is present then the sum of "Var" & "Sep 1QFC" (column B & C) is the "Result" (column D)
• If a "Var" (column B) is not present then the sum of "PRB Forecast" & "Sep 1QFC" (column A & C) is the "Result" (column D)
• If there are zero values then result shows a "-" in the cell
Thanks!
Bookmarks