If and (and) formula to allow a zero answer
 

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

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

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

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

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

AND(A21.31,A2<.95) is not possible so you should get a false result


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=274722

Because A2 can NEVER be greater than 1.31 AND less than 0.95. I think you are
looking for OR:-

In cell C2

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

However, this only sorts out cell C2, I don't know what you have/want in B2, so
I'll guess at something like:-

In cell B2

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004

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

LOL - Take a look at what you just put in there, and then think about how those
two conditions could ever both be TRUE at the same time, which is the whole
point of the AND function. :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"K.S.Warrier" wrote in message
...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004