Hello,
I am looking for a formula in column P that will pull in the value from column I if column I is greater than 0, but if column I is equal to zero the formula will pull in the value from column J if column J has a value greater than zero, and lastly if columns I & J are both 0, the formula will pull in the value from column K. In other words, the value pulled into column P should never be 0. Also, if column I states "Not Benchmarked", then the value in column P would remain as "Not Benchmarked". (see screenshot below)
I am looking for a formula in column P that will pull in the value from column I if column I is greater than 0, but if column I is equal to zero the formula will pull in the value from column J if column J has a value greater than zero, and lastly if columns I & J are both 0, the formula will pull in the value from column K. In other words, the value pulled into column P should never be 0. Also, if column I states "Not Benchmarked", then the value in column P would remain as "Not Benchmarked". (see screenshot below)