Thread: Display a cell as 0 if cell it is copying has no value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jason[_10_] Jason[_10_] is offline
external usenet poster
  
Posts: 3
Default Display a cell as 0 if cell it is copying has no value
here is the formula

=PMT(D6,D7,-D4)

Reply With QuoteReply With Quote