Thread: A1 and B1
View Single Post
  #4  
Old May 17th, 2009, 02:50 PM posted to microsoft.public.excel.misc
Teethless mama
external usenet poster
  
Posts: 3,722
Default A1 and B1
=(A1=0)+A1


"Omar" wrote:

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