Formula Help

[vharp91]

Looking for a formula in column R that has the following logic (see screenshot of spreadsheet below):

• If column I = 1, pull in value from column L into column R
• If column I = 2, pull in value from column M into column R
• If column I = 3, pull in value from column L into column R
• If column I = 0 and column J = 1, pull in value from column N into column R
• If column I = 0 and column J = 2, pull in value from column O into column R
• If column I = 0 and column J = 3, pull in value from column N into column R
• If column I = 0 and column J = 0 and column K = 1, pull in value from column P into column R
• If column I = 0 and column J = 0 and column K = 2, pull in value from column Q into column R
• If column I = 0 and column J = 0 and column K = 3, pull in value from column P into column R
• If column I = “Not Benchmarked”, pull in same value that is in column I (i.e. Not Benchmarked) into column R

 

[Sufiyan97]

Try

=IF(I2="Not Benchmarked",I2,IF(I2=1,L2,IF(I2=2,M2,IF(I2=3,L2,IF(AND(I2=0,J2=1),N2,IF(AND(I2=0,J2=2,),O2,IF(AND(I2=0,J2=3),N2,IF(AND(I2=0,J2=0,K2=1),P2,IF(AND(I2=0,J2=0,K2=2),Q2,IF(AND(I2=0,J2=0,K2=3),P2,""))))))))))

 

[vharp91]

Try

=IF(I2="Not Benchmarked",I2,IF(I2=1,L2,IF(I2=2,M2,IF(I2=3,L2,IF(AND(I2=0,J2=1),N2,IF(AND(I2=0,J2=2,),O2,IF(AND(I2=0,J2=3),N2,IF(AND(I2=0,J2=0,K2=1),P2,IF(AND(I2=0,J2=0,K2=2),Q2,IF(AND(I2=0,J2=0,K2=3),P2,""))))))))))

Thank you so much! The formula is working aside from these three records in the screenshot below that are pulling in blanks but are going by this logic:

• If column I = 0 and column J = 2, pull in value from column O into column R

Any ideas on how to fix this?

 

[Sufiyan97]

Can you click on I207 and J207 and show decimals? like this