HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help

Jimmy

Since the results are all same..there is no need of conditions...

If this post helps click Yes
---------------
Jacob Skaria


"jimmy" wrote:

HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help

jimmy,

The *then ("A3"*"A5"-"A9")* is the same for all 4 lines.

Try:
=IF(AND(A3100,A3<=300),(A3*A5)-A9,"not in range")


Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115770

Just one IF will do...

=IF(AND(A3100,A3<=300),A3*(A5-A9),"")

OR

=IF(AND(A3100,A3<=300),(A3*A5)-A9,"")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Jimmy

Since the results are all same..there is no need of conditions...

If this post helps click Yes
---------------
Jacob Skaria


"jimmy" wrote:

HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help

Just to note
assume a3 = 5
assume a5 = 4
assume a9 = 2
=A3*(A5-A9) = 5*(4-2) = 5*2 = 10
=(A3*A5)-A9 = (5*4)-2 = 20-2= 18
I'm assuming that you know this already

--

Wag more, bark less


"Jacob Skaria" wrote:

Just one IF will do...

=IF(AND(A3100,A3<=300),A3*(A5-A9),"")

OR

=IF(AND(A3100,A3<=300),(A3*A5)-A9,"")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Jimmy

Since the results are all same..there is no need of conditions...

If this post helps click Yes
---------------
Jacob Skaria


"jimmy" wrote:

HEllo,

Could you please help me creating a formula with multiple conditions?

IF "A3" greater than 100 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 150, then ("A3"*"A5"-"A9");
IF "A3" greater than 151 and less or equal than 200, then ("A3"*"A5"-"A9");
IF "A3" greater than 201 and less or equal than 300, then ("A3"*"A5"-"A9");

Thanks for your help