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