Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Question Unanswered: If function Help!!!

    I am trying to create a formula that will allow several options, here are the options

    <85% = the cell times .12
    >85% = 100% the cell times .15
    >100% = 110% the cell times .20
    >110% the cell times .30

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    Assuming cell A1 is 'the cell' in question then try this in the cell where you want the answer

    =A1*IF(A1>1.1,0.3,IF(A1>1,0.2,IF(A1>0.85,0.15,0.12 )))

    This assumes that A1 is a decimal formated as a percentage, (ie 1 dispays as 100%).


    HTH

    MTB

Posting Permissions

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