Results 1 to 12 of 12

Problem with nested IF's and something else.

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    Latvia, Riga
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Problem with nested IF's and something else.

    Hello!
    I'm some sort of amateur on complexed combinations of excel functions, so don't judge me for my non"excel"ish language. :D
    I want to make an automatic column in my table of sold items, which would calculate bonuses depending on requirements, AND IF requirements met,ONLY then calculate bonuses depending on item price. AND thats a problem.
    So, requirements is 355Ls/day or 3 items/day. If person meets these requrements, then he gets bonus. Bonuses depends on sold item price: 250ls (gets 2ls bonus), 300-450Ls (gets 3,5ls bonus) etc.
    I need something like - IF(item price>=355ls OR quantity>=3) then he gets a bonus depending on- IF(item price<250;0"No bonus";IF(item price>=250;2ls;IF(item price>=300;3,5ls.
    I hope somebody will understand, what I need, and will help me on that. If no, then i will continue to type it with my index :D
    Example of material is in attachment. Thanks.
    Attachment 273935
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] nested if then problem
    By Bobby789 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2013, 10:57 AM
  2. Nested If problem!
    By Thu Rein in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2013, 06:12 PM
  3. [SOLVED] Nested IF/OR problem
    By muszynka in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2012, 03:51 PM
  4. Nested IF, AND Problem
    By jamieray in forum Excel General
    Replies: 2
    Last Post: 09-15-2011, 07:08 AM
  5. [SOLVED] nested if vba problem
    By leitek.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2006, 05:15 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