no the discount remains the same
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: no the discount remains the same

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    The discount remains the same throughout

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanx alot mate doing my college assigment

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com