Using the "IF" Statement

[Dave]

Hello,

I've been driving myself just a bit nuts trying to resolve the
following
excel problem:

If the numeric value in a given cell falls within a predefined range
(500 to 1000), I want the value to be multiplied by a constant
value (0.05). If the criteria is not met, I want the cell identified
as
the recipient of this multiplication to reflect a value of 0.00.

Could someone please show me what this formula should look like?
Certainly
would appreciate it.

 

[Norman Harker]

Hi Dave!

Is this what you need?

=IF(AND(A1>=500,A1<=1000),A1*0.05,0)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Lloyd H. London]

Try =IF(AND(A1>=500,A1<=1000),A1*0.05,0)

 

[Bob Phillips]

Dave,

Here's a solution without IF

=AND(A1>=500,A1<=1000)*A1*0.5

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[J.E. McGimpsey]

Just another way:

=(ABS(A1-750)<=250)*A1*0.05

Dave,

Here's a solution without IF

=AND(A1>=500,A1<=1000)*A1*0.5

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)