Hi

B1=(A110000)*MAX(300,A1*0.03)


Arvi Laanemets


"ChrisMattock"
wrote in message
news:ChrisMattock.2ad7sc_1151922904.0152@excelforu m-nospam.com...

KO I have two columns, the first column (A) has some figures. The second
column (B) has one of three scenarios depending on the first column...

If A <10,000 then B will be 0
If A 10,000 but <100,000 B will be 300
If A 100,000 then B = 3% of A

I'm sure this is easy, but I can't do it, I would greatly appreciate
any help you guys can give me.


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=557800