Formula Help

[vharp91]

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)

 

[Sufiyan97]

Try in P2:

=IF(I2="Not Benchmarked",I2,IF(I2>0,I2,IF(J2>0,J2,IF(K2>0,K2,""))))

 

[vharp91]

Try in P2:

=IF(I2="Not Benchmarked",I2,IF(I2>0,I2,IF(J2>0,J2,IF(K2>0,K2,""))))

This worked! Thank you

 

[Sufiyan97]

You're welcome!