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!