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