Need a triggered formula.

[chadontheboat]

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

[Don Guillett]

=if(a2>10,10.00,5.00)

--
Don Guillett
SalesAid Software
[email protected]
"chadontheboat" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[chadontheboat]

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

[Don Guillett]

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

=if(a2>30,20.00,if(a2>10,10.00,5.00))


--
Don Guillett
SalesAid Software
[email protected]
"chadontheboat" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Michael M]

Hi Chad
Not being able to acces your thread, I can't see your exact needs, but:
=IF(A2>30,10,IF(A2>10,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
>
>