quatro pro formula conversion

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am trying to get an array formula from a Quatro Pro
worksheet to work in excel. I can break it apart and it
works but not when I put it altogether? Help, please!

Here is the Quatro Pro version:
@IF(H134=C134,"Holy Cow Batman, You Balance",@IF(H134-
C134>-5#AND#H134-C134<5,"Close Enough to Count Hairs,
Proceed","Great Ceasar's Ghost,You Don't Balance"))

Thanks.
 
=IF(H1=C1,"Holy Cow Batman, You Balance",IF(AND((H1-C1)>-5,(H1-C1)<5),"Close Enough to Count
Hairs, Proceed","Great Ceasar's Ghost,You Don't Balance"))

or

=IF(H1=C1,"Holy Cow Batman, You Balance",IF(ABS(H1-C1)<5,"Close Enough to Count Hairs,
Proceed","Great Ceasar's Ghost,You Don't Balance"))
 
...
...
Here is the Quatro Pro version:
@IF(H134=C134,"Holy Cow Batman, You Balance",@IF(H134-
C134>-5#AND#H134-C134<5,"Close Enough to Count Hairs,
Proceed","Great Ceasar's Ghost,You Don't Balance"))
Click to expand...

Excel provides no #AND# operator, only an AND function. Even so, this lends
itself to alternative treatment.

=IF(ABS(H134-C134)<0.005,"balance",ABS(H143-C134)<5,"close","oops!")

or getting clever

=LOOKUP(ABS(H134-C134),{0,0.005,5},{"balance","close","oops"})
 
Back
Top