Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Conditional Percentage Calculation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Conditional Percentage Calculation

    Hi all

    I 'm really struggling here and would appreciate any help!
    I'm trying to get an IF statement that will calculate commision.
    If a margin on a particular sale is 35% or below, then commision is 0%. If margin is between 36 and 37 %, then commision is 1%, etc...
    Is this doable?? It's been driving me mad all day today.

    Many thanks

  • #2
    Re: If Statement Percentage Calculation

    Hi,

    Try something like..

    =LOOKUP(A1,{0,0.36,0.38},{0,0.01,0.02})

    HTH
    Kris

    ExcelFox

    Comment


    • #3
      Re: If Statement Percentage Calculation

      Try this:
      Assuming cell A2 contains the margin percent.

      =IF(A2<=35%,0%,FLOOR(A2-35%,.01))

      Note: The FLOOR function rounds down to the next lower whole percentage point. If you wish to allow for fractions of a percent then simply replace the FLOOR function with A2-35%.

      Comment

      Trending

      Collapse

      There are no results that meet this criteria.

      Working...
      X