Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

start with the highest
=if(b1110000,500,if(b118000,300 etc

--
Don Guillett
SalesAid Software

"sssspro" wrote in message
...
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

Thank you Don. I did this, and it still didn't work.

=IF(B1110001,500,0),IF(8001B11<10000,300,0),IF(6 501B11<8000,150,0),IF(B11<6500,0,0)

Am I missing sometihng? parenthases, =, commas?



"Don Guillett" wrote:

start with the highest
=if(b1110000,500,if(b118000,300 etc

--
Don Guillett
SalesAid Software

"sssspro" wrote in message
...
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

sssspro wrote:
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

=IF(B11<6500,0,IF(AND(B116500,B11<8000),150,IF(AN D(B118000,B11<10000),300,IF(B1110000,500,"None") )))


You'll need to modify this a bit... If you have a value of either 6500,
8000, or 10000 it will reurn a false ("None" string). Incorporate in
greater than or equal to, less than or equal to's to get it to accept
those values


HTH

Sandy


sssspro wrote:
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

THANK YOU THANK YOU THANK YOU!!!!!!


It works!!! I knew I had to be close. I appreciate your help, and yes it
did help!

It looks like you have too many arguments...Don suggested:
=if(b1110000,500,if(b118000,300 etc

But, you have
=IF(B1110001,500,0),IF...

You're saying if B11 is greater than 10001, insert 500, if not, insert 0.
Don is saying if B11 is greater than 10000, insert 500, if not, if B11 is
greater than 8000, insert 300. The '0' that you have is the "if not" section
of the argument.

Hope this makes sense!!

MT

"sssspro" wrote:


Thank you Don. I did this, and it still didn't work.

=IF(B1110001,500,0),IF(8001B11<10000,300,0),IF(6 501B11<8000,150,0),IF(B11<6500,0,0)

Am I missing sometihng? parenthases, =, commas?



"Don Guillett" wrote:

start with the highest
=if(b1110000,500,if(b118000,300 etc

--
Don Guillett
SalesAid Software

"sssspro" wrote in message
...
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

Just to be different...

=150*((B116500)+(B118000))+200*(B1110000)

--
Dana DeLouis
Windows XP & Office 2003

"sssspro" wrote in message
...
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

Yes, you did NOT do as I suggested. You don't need the <10000, etc. Just the
moving from large to small.
Think about it. An if formula says that if this is true then 500 but if it
is not true move on to the next test.
--
Don Guillett
SalesAid Software

"sssspro" wrote in message
...

Thank you Don. I did this, and it still didn't work.

=IF(B1110001,500,0),IF(8001B11<10000,300,0),IF(6 501B11<8000,150,0),IF(B11<6500,0,0)

Am I missing sometihng? parenthases, =, commas?



"Don Guillett" wrote:

start with the highest
=if(b1110000,500,if(b118000,300 etc

--
Don Guillett
SalesAid Software

"sssspro" wrote in message
...
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be
appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I
am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)

Sandy, See my post. You do NOT need the <<
--
Don Guillett
SalesAid Software

"Sandy" wrote in message
oups.com...
=IF(B11<6500,0,IF(AND(B116500,B11<8000),150,IF(AN D(B118000,B11<10000),300,IF(B1110000,500,"None") )))


You'll need to modify this a bit... If you have a value of either 6500,
8000, or 10000 it will reurn a false ("None" string). Incorporate in
greater than or equal to, less than or equal to's to get it to accept
those values


HTH

Sandy


sssspro wrote:
Ok, I should be able to do this and just can't get it to work.

Here's the deal, I need a formula to do this:

If cell B11 is < 6500 then return 0
If cell B11 is 6500 and <8000 return 150
If cell B11 is 8000 and < 10000 return 300
If cell B11 is 10000 return 500


Here's what I've got and it isn't working, any help would be appreciated:

(Sarah feeling stupid this morning) - I know it is something simple I am
missing here. Thanks for that help!!!!


=IF(B11<6500,0,0)=IF(6501< B11<8000,150, 0)=IF(8001<B11<10000,
300,0)=IF(B1110001, 500,0)