IF Function with < &
 

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

A B
1.5 10
4 3

If 2A<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(2A1, (A-1)*B,B)

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

Thanks for the help!!!


--
acebrown
------------------------------------------------------------------------
acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640
View this thread: http://www.excelforum.com/showthread...hreadid=568085

IF Function with < &
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"acebrown" wrote in message
...
|
| I'm having trouble getting the If function to work...
|
| A B
| 1.5 10
| 4 3
|
| If 2A<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(2A1, (A-1)*B,B)
|
| Neither did:
| =IF(A<2,(A-1)*B,IF(A1,B))
|
| Thanks for the help!!!
|
|
| --
| acebrown
| ------------------------------------------------------------------------
| acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640
| View this thread: http://www.excelforum.com/showthread...hreadid=568085
|

IF Function with < &
 

You need to do it like this:

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

/Møller


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=568085

IF Function with < &
 

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

Regards

Trevor


"acebrown" wrote in
message ...

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

A B
1.5 10
4 3

If 2A<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(2A1, (A-1)*B,B)

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

Thanks for the help!!!


--
acebrown
------------------------------------------------------------------------
acebrown's Profile:
http://www.excelforum.com/member.php...o&userid=36640
View this thread: http://www.excelforum.com/showthread...hreadid=568085

IF Function with < &
 

thank you kindly!


--
acebrown
------------------------------------------------------------------------
acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640
View this thread: http://www.excelforum.com/showthread...hreadid=568085