jalynbCopper ContributorJun 21, 2019Formula 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 ...Show More
TwifooSilver ContributorJun 21, 2019If your Quantity is in A2, the formula for total price in B2 is:=A2*7-INT(A2/3)
