depending on value use different coloumb

[JaykSA]

p34 should have value. m34 and o34 if both are 0, p34=0. but if one has a value more than 0 use that for value in p34?

 

[Jonmo1]

What if BOTH M34 and O34 have a value, which one do you want?

 

[JaykSA]

no only one will have. any idea?

 

[Jonmo1]

Try
=MAX(M34,O34)

 

[JaykSA]

that was easy. thank you!

 

[Jonmo1]

You're welcome.