View Single Post
  #8   Report Post  
K.S.Warrier
 
Posts: n/a
Default

hi,
I think you may require the following
In b2 put the formula as =if(and(a21.31,a2<.95),"",round(a2,2))
You have shown one more "" before "" in the above.Please try.
K.S.Warrier

"inthestands" wrote:

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