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

--
Regards
Frank Kabel
Frankfurt, Germany

"Frank Kabel" schrieb im Newsbeitrag
...
Hi
try:
=IF(OR(A21.31,A2<.95)"","",ROUND(B2,2))


--
Regards
Frank Kabel
Frankfurt, Germany

"inthestands" schrieb im
Newsbeitrag
...
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