Sorry

the second formula should have been:

=IF(AND(A2.95,A2<1.31),"",ROUND(B2,2))


Regards

Trevor


"Trevor Shuttleworth" wrote in message
...
I suspect this is what you want:

=IF(OR(A21.31,A2<.95),"",ROUND(B2,2))

or

=IF(OR(A2.95,A2<1.31),"",ROUND(B2,2))

A2 cannot be greater than 1.31 AND less than 0.95. You can have a value
less than 1.31 AND greater than 0.95. And you can have a value that is
greater than 1.31 OR less than 0.95.

Regards

Trevor


"inthestands" wrote in message
...
I am trying to use the following formula
=IF(AND(A21.31,A2<.95)"","",ROUND(B2,2))

The response I am trying to get is if A2 Is greater than 1.31 and less
than
.95 then give me no answer in B2, but if A2 falls within this parameter,
then
round B2 to two decimals into C2. What am I doing wrong?

thanks in advance,
--
inthestands