Thread: A1 and B1
View Single Post
  #1  
Old May 17th, 2009, 05:15 AM posted to microsoft.public.excel.misc
Omar
external usenet poster
  
Posts: 16
Default A1 and B1
Dear all,
I have two cells A1 and B1. B1 takes from A1
If A1≠ 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