Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-714347%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714347%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20auto%20generate%20when%20a%20number%20is%20put%20it%20to%20change%20it%20to%20something%20else%3F%20I%20sell%20Jams%20and%20we%20sometime%20give%20discounts%3A%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3EIf%201%20is%20typed%20in%20is%20there%20a%20way%20to%20change%20that%20to%207%3C%2FP%3E%3CP%3EIf%202%20is%20typed%20in%20is%20there%20a%20way%20to%20change%20that%20to%2014%3C%2FP%3E%3CP%3EIf%203%20is%20typed%20in%20is%20there%20a%20way%20to%20change%20that%20to%2020%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20pretty%20much%20a%20jar%20cost%20%247%20and%20every%20three%20jars%20%241%20is%20taken%20off%2C%20or%20if%20there%20is%20a%20formula%20I%20can%20use%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-714347%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-714393%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714393%22%20slang%3D%22en-US%22%3EIf%20your%20Quantity%20is%20in%20A2%2C%20the%20formula%20for%20total%20price%20in%20B2%20is%3A%3CBR%20%2F%3E%3DA2*7-INT(A2%2F3)%3C%2FLINGO-BODY%3E
jalynb
Occasional Visitor

Is there a way to auto generate when a number is put it to change it to something else? I sell Jams and we sometime give discounts:

For example:

If 1 is typed in is there a way to change that to 7

If 2 is typed in is there a way to change that to 14

If 3 is typed in is there a way to change that to 20

 

So pretty much a jar cost $7 and every three jars $1 is taken off, or if there is a formula I can use that.

1 Reply
If your Quantity is in A2, the formula for total price in B2 is:
=A2*7-INT(A2/3)