Below is a snip of the Data. I need a formula that looks for the number in Column D. Then if the number is in column F, return the sum as a negative number. If the number is in Column G, return the sum as a positive number. If this possible?
Example - # in Column D is "5703". return -12,163.83. / SAME formula for "5704" in column D would return 6,317,733.95.
I want the formula to look for a non-zero number in both Column F & G and then return the appropriate sum of the positive or negative number.
Example - # in Column D is "5703". return -12,163.83. / SAME formula for "5704" in column D would return 6,317,733.95.
I want the formula to look for a non-zero number in both Column F & G and then return the appropriate sum of the positive or negative number.