=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