Thread: #VAlUE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default #VAlUE

A3 =IF(A2=0," ",A1/A2)

On Apr 1, 6:59*pm, Chi wrote:
Hi, the #VALUE error appeared when I deleted value of the cells.

EX: My formula is A3= A1/A2. The formula works fine, but after I clear the
value of A1 and A2, the #VALUE shows the A3. Would you please show me how to
stop the error.

Please help
Thank you so much
Chi