Are you sure that your reference cell has a number and not text? What does
=ISNUMBER(F7) give you?

If you've done the same elsewhere as in your formula below and put your
numbers in quotes, they'll be treated as text and evaluated as zero.
--
David Biddulph

"CBZ" wrote in message
...
Mike my ref. cell is reading 71.3 and it is returning a 0? Comments?

"Mike H" wrote:

if you want an if statement use:-

=IF(F7=80,"9.1%",IF(F7=75,"13.6%",IF(F770,"16.9 %",IF(F740,"17.3%",0))))

Mike

"CBZ" wrote:

Mike I need to capture any data pt. in b/w 0 to 100 so that is why I
used < &
<. So not sure how to do this on a lookup?

Celeste

"CBZ" wrote:

Sorry... for the confusion if ref. cell f7 is 83.2% as an example I
want the
formula to return 9.1%.

Celeste

"CBZ" wrote:

CAn someone detect what I am doing wrong on the following formula:


=IF(F7=40%<=70%,"17.3%",IF(F770%<=75%,"16.9%",IF (F7=75%<=80%,"13.6%",IF(F7=80%<=100%,"9.1%",0))) )

Ideally if the ref cell (f7) has 83.2% I want 13.6% returned.

Thanks so much.

Celeste