IF Function with < & >

[acebrown]

I'm having trouble getting the If function to work...

A B
1.5 10
4 3

If 2>A<1, then (A-1)*B
If not, then B

So the result for row1 above should be 5 ((1.5-1)*10) and row2 shoul
be 3 (3).

The following did not work:
=IF(2>A>1, (A-1)*B,B)

Neither did:
=IF(A<2,(A-1)*B,IF(A>1,B))

Thanks for the help!!

 

[Niek Otten]

=IF(AND(A1>1,A1<2),(A1-1)*B1,B1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I'm having trouble getting the If function to work...
|
| A B
| 1.5 10
| 4 3
|
| If 2>A<1, then (A-1)*B
| If not, then B
|
| So the result for row1 above should be 5 ((1.5-1)*10) and row2 should
| be 3 (3).
|
| The following did not work:
| =IF(2>A>1, (A-1)*B,B)
|
| Neither did:
| =IF(A<2,(A-1)*B,IF(A>1,B))
|
| Thanks for the help!!!
|
|
| --
| acebrown
| ------------------------------------------------------------------------
| acebrown's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36640
| View this thread: http://www.excelforum.com/showthread.php?threadid=568085
|

 

[c991257]

You need to do it like this:

=if(and(condition1,condition2),then,else)

/Mølle

 

[Trevor Shuttleworth]

=IF(AND(A>1,A<2),(A-1)*B,B)

Regards

Trevor

 

[acebrown]

thank you kindly!