Thread: Zero Value Ranked
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
  
Posts: 102
Default Zero Value Ranked

Disregard the last one, this is what I meant to send:

try this:

=IF(G21=0,"0"%,IF(ISERROR((C21-G21)/G21),0,(C21-G21)/G21))

Reply With QuoteReply With Quote