ExcelBanter - IF Statement Reading Zero's

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement Reading Zero's (https://www.excelbanter.com/excel-discussion-misc-queries/448817-if-statement-reading-zeros.html)

MichaelPK

IF Statement Reading Zero's

If a number in cell AX2 is between -5 and 10, I want there to be “10” in cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in the cell and not “10.”

The formula I am using is: =IF(AND(AX2-5,AX2<10)*AX2,10,0)

Thank You for any help/insight that can be provided.

Claus Busch

IF Statement Reading Zero's

Hi Michael,

Am Tue, 28 May 2013 16:22:27 +0100 schrieb MichaelPK:

If a number in cell AX2 is between -5 and 10, I want there to be “10” in
cell AS2, but for some reason if AX2 is a “0”, a “0” is placed in the
cell and not “10.”

try:
=AND(AX2-6,AX2<11)*10
or
=IF(AND(AX2-6,AX2<11),10,"")

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

MichaelPK

Quote:

Originally Posted by MichaelPK (Post 1612062)

The solution: Remove the *AX2

All times are GMT +1. The time now is 07:31 PM.