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

On Sep 26, 5:45*pm, SeeStation
wrote:
Thanks for your assistance - we are almost the *Let me explain - I am
working with pricing margins. *If the margin is too high, my price is too
low. *If the margin is too low, my price is too high. *If my price is just
right it will fall into a resonable margin range that will allow my wholesale
customers to sell my product for retail value and still be competitive in the
market. *OK - I got one more issue with this example and it revolves around
the value in a1.

a1=((E21-E20)/E21)*100
if E21 contains a vlaue of "Not Available" then a1 displays "#VALUE!"
and in turn, a1 displays the same thing as well as b1



"ShaneDevenshire" wrote:
Hi,

It seems counter intuitive to call somethng over 26 low and something under
20 high? *But if that is so then you could use

=IF(A1<20,"High",IF(A126,"Low",IF(ISERR(A1),NA(), "Within Margin")))

Notice I am checking for any error in A1 not just VALUE errors, but I double
that matters.
--
Thanks,
Shane Devenshire

"SeeStation" wrote:

Cell a1 contains the result of a function (19.94)

how can I make a function for B1
b1="High" if a1 is <20
b1="Low" if a1 is 26
b1="Within Margin" if 26<a120
b1="N/A" if false or if a1 contains "#VALUE" as a result of it's function
not being fullfilled?

Thanks!- Hide quoted text -

- Show quoted text -