If certain number apply specific discount

Excel Help for If Certain Number Apply Specific Discount in Analyzing Corporate Financial Data

If Certain Number Apply Specific Discount

Rate this: (3/5 from 1 vote)

	I have cell D4 were a user types in a number. If the number is equal to or less than cell J4 I want to apply the discount at J5, if the number is greater than J4 but less than cell K4 I want to apply the discount at K5, if the number is greater than K4 I want to apply the discount at L5. Anybody got a solution Thanks
	Posted by piper1509 on 22 Apr 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Multiple IF function required Rate this: (3/5 from 1 vote) The formula for this is as follows: =IF(D4<J4,D4*(1-J5),IF(AND(D4>J4,D4<K4),D4*(1-K5),D4*(1-L5)))
	Excel Business Forums Administrator
	Posted by Excel Helper on 22 Apr 2010

Displaying page 1 of 1