Thread: #DIV/0! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] erin@ecopainting.ca is offline
external usenet poster
 
Posts: 1
Default #DIV/0! error

I have a spreadsheet where the formula is =(G38-E38-F38)/E38 and goes down the entire column. Its a percentage that shows up when there are numbers put into the rows, but it shows the #DIV/0! error when there isn't anything in the rows. Is there a way to just keep the cell blank when there isn't any numbers in the row instead of showing an error?