You're welcome. Good to see that you have taken the suggestions
further and come up with your own solutions.

Pete

On Sep 26, 8:35*pm, SeeStation
wrote:
Thanks Pete_UK - it wasn't quite what I was looking for, but you got me in
the right direction. *Just in case anyone else was following this thread,
here is my working solution:

a1=IF(ISERROR((E21-E20)/E21*100),"Not Available",(E21-E20)/E21*100)

b1=IF(F21<20,"Dealer Cost is High",IF(F21="Not Available","Not
Available",IF(F2126,"Dealer Cost is Low",IF(ISERR(F21),NA(),"Within
Margin"))))

Under Pete_UK's example the ,"",( in the function for cell a1 was applied in
b1 as <20 which displayed "Dealer Cost is Low". *Now if the cells E21 or A1
read 'Not Available', so does b1.

You guys pointed me in the right direction and got me 99% of the way there. *
Thanks a bunch!



"Pete_UK" wrote:
You could change your formula in A1 to this:

=IF(ISERROR((E21-E20)/E21*100),"",(E21-E20)/E21*100)

This will show a blank in A1 instead of an error message.

Hope this helps.

Pete