Results 1 to 6 of 6

can't write proper if statement

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Chicago, il
    MS-Off Ver
    Excel 2010
    Posts
    10

    can't write proper if statement

    I can't seem to get the formula right.

    It is a salesperson bonus

    I have the over margin dollars in J7. (this could be a negitave number)

    I wanted to write a formula using J7 number.

    IF J7 is less than 0 = 0
    IF J7 is greater than 0 but less than 50,000 they get 7.5% commission of J7
    IF J7 is greater than 50,000 they get 7.5 % of the first 50,000 and 5% of the amount over 50,000

    Thanks for any help
    Last edited by ghuber34; 02-17-2014 at 12:35 PM. Reason: wrong title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1