I couldnt tell what the question was. I was pretty sure this wasn't the best answer
Quote:
|
=IF(ISERROR((F10-D10)/D10)=TRUE;"-";(F10-D10)/D10)
|
He complained that it should equal 100%, even though D10 is zero, so I don't know what he's after.
You don't have to use Iserr or Iserror anymore. You never had to say =TRUE.