Thread: Zero Value Ranked
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bsmile Bsmile is offline
external usenet poster
  
Posts: 2
Default Zero Value Ranked
Thank you. That worked!

"Mark" wrote:


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