IF cell is currency, not text, and over this much?

[Ed]

I am trying to sort out a list using a helper column. The column I am
trying to sort out has monetary amounts with cells formatted as currency.
At odd places in the column, though, are headers in cells formatted as text.
I put an IF formula in my helper column to give me "Yes" if the money amount
was over a certain value. Unfortunately, it's also giving me a "Yes" at
every text cell. Is there a formula that will help me sort this out?

Ed

 

[Bob Phillips]

Use something like

AND(ISNUMBER(E13),E13>5)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Ed]

Thanks, Bob. I couldn't make AND work, but I did get
=IF(ISNUMBER(E1), IF( E1>2,"Yes", "No"), "No")
which worked. So ISNUMBER was my ticket.

The boost is greatly appreciated.
Ed

 

[Bob Phillips]

This should work Ed

=IF(AND(ISNUMBER(E1), E1>2),"Yes", "No")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Harlan Grove]

Bob Phillips wrote...

This should work Ed

=IF(AND(ISNUMBER(E1), E1>2),"Yes", "No")

If the threshold value is positive, then all that's needed would be

=IF(N(E1)>2,"Yes","No")

because N(..) evaluates text and empty cells as zero. Same for FALSE
values, but TRUE would evaluate as 1. Also, if error values would need
to be filtered, neither formula above would work, so perhaps the ideal
in that case would be

=IF(COUNTIF(E1,">2"),"Yes","No")

 

[Ed]

Thank you both, Bob and Harlan. Probably the best thing is that I actually
understood _why_ your formulas worked after I read the Help topics. I
actually seem to be learning something! <g>
Ed