Trying to Create a Discount

**natttruck** · 03-06-2014, 01:35 PM

Hi all, I am trying to figure out how to calculate something and would appreciate any help.

I have a set of data, here is one for an example:
Date Invoice Total Discount
7/13/13 $ 11,790.00 1179

if date (7/13/13) is greater than 8/31/13, I want the total discount column to calculate 10% of value in invoice column. Thanks!

**shg** · 03-06-2014, 01:37 PM

=if(dateValue > --"8/31/2013", 10%*invoiceValue, 0)

**natttruck** · 03-06-2014, 01:50 PM

Thanks. How would I lock the date when I drag down?

**shg** · 03-06-2014, 01:54 PM

Lock what date? Isn't the date different (in general) for each invoice?

**natttruck** · 03-06-2014, 02:00 PM

It is giving out the output #NAME? so I am guessing I have to lock something?

**shg** · 03-06-2014, 02:13 PM

Replace dateValue with the cell where the invoice date appears, and invoiceValue with the cell where the invoice value appears.

Trying to Create a Discount

LinkBack

Thread Tools

Rate This Thread

Display

Trying to Create a Discount

Re: Trying to Create a Discount

Re: Trying to Create a Discount

Re: Trying to Create a Discount

Re: Trying to Create a Discount

Re: Trying to Create a Discount

Thread Information

Users Browsing this Thread

Similar Threads

create a function for Discount if qty > 50 then take 5% off total

[SOLVED] create a function for Discount if qty > 50 then take 5% off total

[SOLVED] create a function for Discount if qty > 50 then take 5% off total

[SOLVED] create a function for Discount if qty > 50 then take 5% off total

[SOLVED] create a function for Discount if qty > 50 then take 5% off total

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions