no the discount remains the same

Silver · Mar 15th, 2002, 06:43 AM

The discount remains the same throughout

cdiffell · Mar 15th, 2002, 06:49 AM

Well, you can do something like this:

=if(A1>=100,(A1*2%),)

This will take the number in A1, check to see if it's 100 or greater, then multiply it by 2%. Of course, you can substitute another percent or even multiply a different cell in that row by the %; just change the second A1 to whatever other cell your discount calc is in. This will create a whole column (if you copy it down all your rows) with the discount amount, which you can then subtract from the original to get the discounted price.

Hope this helps

CND

Silver · Mar 15th, 2002, 06:51 AM

Thanx alot mate

doing my college assigment

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 06:43 AM	#1
Silver New Member Join Date: Mar 2002 Posts: 5	The discount remains the same throughout

Mar 15th, 2002, 06:49 AM	#2
cdiffell New Member Join Date: Mar 2002 Location: Clearwater, FL Posts: 46	Well, you can do something like this: =if(A1>=100,(A1*2%),) This will take the number in A1, check to see if it's 100 or greater, then multiply it by 2%. Of course, you can substitute another percent or even multiply a different cell in that row by the %; just change the second A1 to whatever other cell your discount calc is in. This will create a whole column (if you copy it down all your rows) with the discount amount, which you can then subtract from the original to get the discounted price. Hope this helps CND

Mar 15th, 2002, 06:51 AM	#3
Silver New Member Join Date: Mar 2002 Posts: 5	Thanx alot mate doing my college assigment