Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
Hello
could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
Yes. Use Solver.
-- Gary''s Student - gsnu200815 "john" wrote: Hello could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
Solver is a great tool but if you just want a formula see if this works for
you. Assume that cell A1 contains your quantity and cell B1 contains your price then in cell C1 enter =IF(A1<100,A1*B1,A1*B1*0.9) which would give you a 10% discount when quantity is greater than 99. "john" wrote: Hello could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
thanks is it possible to send you a copy of what i am trying to do
thanks "Gary Mc" wrote: Solver is a great tool but if you just want a formula see if this works for you. Assume that cell A1 contains your quantity and cell B1 contains your price then in cell C1 enter =IF(A1<100,A1*B1,A1*B1*0.9) which would give you a 10% discount when quantity is greater than 99. "john" wrote: Hello could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
Thanks
your help was the only decent response i have recieved thankyou, in the if formula can you use multiple <in one line to perform calculations according to wherther a criteria is met thanks john "Gary Mc" wrote: Solver is a great tool but if you just want a formula see if this works for you. Assume that cell A1 contains your quantity and cell B1 contains your price then in cell C1 enter =IF(A1<100,A1*B1,A1*B1*0.9) which would give you a 10% discount when quantity is greater than 99. "john" wrote: Hello could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for different values
Hi,
Sure, but it may not be the best solution even if it can be done. Without concrete examples its hard for the people here to give you specific solutions. Here is an example which might relate to your question: =IF(A1<"",IF(B1<"",IF(A1<100,A1*B1,A1*B1*0.9),"" ),0) If this helps, please click the Yes button. Cheers, Shane Devenshire "john" wrote: Thanks your help was the only decent response i have recieved thankyou, in the if formula can you use multiple <in one line to perform calculations according to wherther a criteria is met thanks john "Gary Mc" wrote: Solver is a great tool but if you just want a formula see if this works for you. Assume that cell A1 contains your quantity and cell B1 contains your price then in cell C1 enter =IF(A1<100,A1*B1,A1*B1*0.9) which would give you a 10% discount when quantity is greater than 99. "john" wrote: Hello could somebody tell me if its possible in excel 2007 to write a formula that produces a figure but can produce another figure if the original is not whats required eg if the price of sugar is 5pence and i want 1 =5pence but if i want more than 100 i would expect a discount meaning the figure produced is wrong and should be another lower figure |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display formula values instead of the formula? | Excel Worksheet Functions | |||
Show and copy values in formula bar containing a formula | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) |