"IF" Function With Percentages

[STL547]

Hi,

Im trying to use an "if then" statement to show if a number is larger than 2% of 1,500,000 or smaller than 2% 1,500,000 then FALSE, if in-between the rage then TRUE.

In other words, if number is within the range of 2% of X - the statement is TRUE and if outside then FALSE.

Any suggestions?

 

[JoeMo]

Assuming the number to be tested is in cell A1:
=IF(A1>=2%*1500000,TRUE,FALSE)

 

[AlphaFrog]

Try something like this...
=AND(A1>1500000*(1-2%),A1<1500000*(1+2%))

The AND function returns TRUE or FALSE

 

[jtakw]

Hi,

How about:

Excel 2010
	A	B	C
1	1,500,000	1,470,000	FALSE
Sheet1

Cell Formulas
Range	Formula
C1	=OR(B1>A1*1.02,B1)

 

[jtakw]

Oops, I got the TRUE/FALSE backwards, use this:

Excel 2010
	A	B	C
1	1,500,000	1,470,000	TRUE
Sheet1

Cell Formulas
Range	Formula
C1	=AND(B1<=A1*1.02,B1>=A1*0.98)