Hey i am pretty novice in teh whole figuring out formulas i know my
basics but it does not go past that.

what i need is a formula that will change the formula of a column of
cells based on a number in a different cells. i am trying to create a
purchase order and if the customer orders more than 10 items the cost
of teh item changes. i really need help with this. please comment if
you need more information.
Thanks
Chad


--
chadontheboat
------------------------------------------------------------------------
chadontheboat's Profile: http://www.excelforum.com/member.php...o&userid=35432
View this thread: http://www.excelforum.com/showthread...hreadid=552054

=if(a210,10.00,5.00)

--
Don Guillett
SalesAid Software

"chadontheboat"
wrote in message
news:chadontheboat.29exan_1150323002.1823@excelfor um-nospam.com...

Hey i am pretty novice in teh whole figuring out formulas i know my
basics but it does not go past that.

what i need is a formula that will change the formula of a column of
cells based on a number in a different cells. i am trying to create a
purchase order and if the customer orders more than 10 items the cost
of teh item changes. i really need help with this. please comment if
you need more information.
Thanks
Chad


--
chadontheboat
------------------------------------------------------------------------
chadontheboat's Profile:
http://www.excelforum.com/member.php...o&userid=35432
View this thread: http://www.excelforum.com/showthread...hreadid=552054

thanks alot for the super fast reply, hate to ask but i have one more
question in regardes to that formula. if the customer orders 30 or more
parts it changes it again.
please let me know
Chad


--
chadontheboat
------------------------------------------------------------------------
chadontheboat's Profile: http://www.excelforum.com/member.php...o&userid=35432
View this thread: http://www.excelforum.com/showthread...hreadid=552054

perhaps you can help yourself by looking in the help index for IF

=if(a230,20.00,if(a210,10.00,5.00))


--
Don Guillett
SalesAid Software

"chadontheboat"
wrote in message
news:chadontheboat.29eygb_1150324502.2036@excelfor um-nospam.com...

thanks alot for the super fast reply, hate to ask but i have one more
question in regardes to that formula. if the customer orders 30 or more
parts it changes it again.
please let me know
Chad


--
chadontheboat
------------------------------------------------------------------------
chadontheboat's Profile:
http://www.excelforum.com/member.php...o&userid=35432
View this thread: http://www.excelforum.com/showthread...hreadid=552054

Hi Chad
Not being able to acces your thread, I can't see your exact needs, but:
=IF(A230,10,IF(A210,20,5))
So, if A2 is greater than 30 it gives 10.
If A2 is greater than 10 it gives 20
If less than 10 it gives 5

Does that help

Regards
Michael M

"chadontheboat" wrote:


thanks alot for the super fast reply, hate to ask but i have one more
question in regardes to that formula. if the customer orders 30 or more
parts it changes it again.
please let me know
Chad


--
chadontheboat
------------------------------------------------------------------------
chadontheboat's Profile: http://www.excelforum.com/member.php...o&userid=35432
View this thread: http://www.excelforum.com/showthread...hreadid=552054