Thread: How do I add iserr or iserror to this
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neall Neall is offline
external usenet poster
  
Posts: 95
Default How do I add iserr or iserror to this
Trying to get rid of the #value to the cells that are not currently populated
in cells with this if statement

=IF(M29-(M29*Disc),M29-(M29*Disc),M29)

Any help would be great

Thanks

--
Neall
Reply With QuoteReply With Quote