| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi,
I have 3 fields. [unitprice] [quantity] [discount] Total  [unitprice]*[quantity])*[discount]This works great unless the discount is zero. How can I fix this. I'm thinking an if statement somewhere but I had off yesterday so my brain is not functioning today. Thanks in advance for your help. Sincerely, Ken |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Your formula does not work.
$1.00 x 2 x 30% = $0.60 -- Rick B "KenRamoska" <(E-Mail Removed)> wrote in message news:93A992FC-AFD2-4381-A088-(E-Mail Removed)... > Hi, > I have 3 fields. [unitprice] [quantity] [discount] > > Total [unitprice]*[quantity])*[discount]> > This works great unless the discount is zero. How can I fix this. I'm > thinking > an if statement somewhere but I had off yesterday so my brain is not > functioning today. Thanks in advance for your help. > Sincerely, > Ken |
|
|
|
|
|||
|
Guest
Posts: n/a
|
KenRamoska wrote:
> Hi, > I have 3 fields. [unitprice] [quantity] [discount] > > Total [unitprice]*[quantity])*[discount]> > This works great unless the discount is zero. How can I fix this. I'm > thinking > an if statement somewhere but I had off yesterday so my brain is not > functioning today. Thanks in advance for your help. > Sincerely, > Ken Can I assume that if a customer gets a 10% discount your "discount" would be 0.90 If there is no discount then your "discount" should indicate 1.0 -- Joseph Meehan Dia duit |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Rick, looks like you are having a tough Tuesday also.
If you look closer I have used ()'s in my formula. Taking what you wrote... ( $1.00 x 2) x 30% = Does work for everything but a 0% possibility. If you look one post below another person suggested a possible solution. "Rick B" wrote: > Your formula does not work. > > > $1.00 x 2 x 30% = $0.60 > > > -- > Rick B > > > > "KenRamoska" <(E-Mail Removed)> wrote in message > news:93A992FC-AFD2-4381-A088-(E-Mail Removed)... > > Hi, > > I have 3 fields. [unitprice] [quantity] [discount] > > > > Total [unitprice]*[quantity])*[discount]> > > > This works great unless the discount is zero. How can I fix this. I'm > > thinking > > an if statement somewhere but I had off yesterday so my brain is not > > functioning today. Thanks in advance for your help. > > Sincerely, > > Ken > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Yes, but you might reconsider the name of your field. If a customer pays
90% of retail, then they are not getting a 90% "discount". -- Rick B "KenRamoska" <(E-Mail Removed)> wrote in message news:9DC2BD54-A933-4859-A053-(E-Mail Removed)... > Rick, looks like you are having a tough Tuesday also. > If you look closer I have used ()'s in my formula. > Taking what you wrote... > ( $1.00 x 2) x 30% = Does work for everything but a 0% possibility. > > If you look one post below another person suggested a possible solution. > > > "Rick B" wrote: > >> Your formula does not work. >> >> >> $1.00 x 2 x 30% = $0.60 >> >> >> -- >> Rick B >> >> >> >> "KenRamoska" <(E-Mail Removed)> wrote in message >> news:93A992FC-AFD2-4381-A088-(E-Mail Removed)... >> > Hi, >> > I have 3 fields. [unitprice] [quantity] [discount] >> > >> > Total [unitprice]*[quantity])*[discount]>> > >> > This works great unless the discount is zero. How can I fix this. I'm >> > thinking >> > an if statement somewhere but I had off yesterday so my brain is not >> > functioning today. Thanks in advance for your help. >> > Sincerely, >> > Ken >> >> >> |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Excel formula to Access Query formula | SJW_OST | Microsoft Access Queries | 6 | 29th May 2008 07:55 PM |
| Help creating query in Access or should I be using a formula in Ex | =?Utf-8?B?d2lsYnVyMTM=?= | Microsoft Access Queries | 3 | 9th Jul 2007 01:30 AM |
| Creating a query that creates rows based off a formula | WAstarita | Microsoft Access Queries | 1 | 15th Mar 2006 12:36 PM |
| Creating A Excel Formula Question | Ryan | Microsoft Excel Misc | 3 | 8th Jan 2004 09:30 PM |
| Creating Specific Excel Formula Question. | Ryan | Microsoft Excel Programming | 5 | 8th Jan 2004 07:00 PM |
