Thread: Excel help please (re: isblank() )
View Single Post
  #2  
Old 30th January 2005, 12:22 PM
Shaun Shaun is offline
Member
  
Join Date: Jan 1970
Location: Western Australia
Posts: 3,408
Default
leave the formating to this $0.00 that is currency say cell A1 contains the blank try this
=if(A1=0.00,"",100/A1)
Reply With Quote