View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Allan Grates[_2_] Allan Grates[_2_] is offline
external usenet poster
 
Posts: 6
Default #DIV/O! help to show zero.

I've researched the forum and tried many different solutions. Still having
problems to get my formula to show zero.

In Cell AB277: (V287/F287)-1, to be shown as a percentage, but when there is
a null number in both V287 & F287 it shows #Div/0!. Instead, I'd like cell
AB277 to show zero (0). Would appreciate the help.

Thanks, Allan