On Mon, 3 Jul 2006 05:34:17 -0500, ChrisMattock
wrote:


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.


=IF(A1<10000,0,IF(A1<100000,300,A1*0.03))

Note that you did not define what you want to happen if A1 is exactly equal to
10,000 and/or 100,000. If my assumptions are incorrect as to what should
happen at these points, change the equality symbol accordingly.


--ron