Dear all,
I have two cells A1 and B1. B1 takes from A1
If A1$B!b(B zero, I want the real digit in A1 to be presented in B1, but if
A1=zero, then I need to put 100% in B1.
Is there any specific formula to achieve that?
Many thanks in advance