Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Anonymous
Anonymous asked in Computers & InternetSoftware · 1 decade ago

Excel IF statement help?! Easy 10 pts.?

i need to put this statement in a formula:

company X pays 30 cents/mile for the first 200 miles and 20 cents per mile for mileage over 200. how would i place that in an If statement in Excel?

Easy 10 pts!!

5 Answers

Relevance
  • siti Vi
    Lv 6
    1 decade ago
    Favorite Answer

    =IF(A1 <= 200, A1 * 0.3, 200 * 0.3 + (A1-200) * 0.2)

    if we use logical-test: A1 < 201,

    200,001 - 200,999 is considered as first 200 miles

  • Inter B
    1 decade ago

    =IF(miles<201 , miles*30 , 200*30 + (miles-200)*20)

  • Anonymous
    1 decade ago

    200(30)+10(X)

    Source(s): algebra
  • AJ
    Lv 7
    1 decade ago

    If(A2<201, .3*A2,((A2-200)*.2)+60)

    Where A2 is the cell with the number of miles

  • How do you think about the answers? You can sign in to vote the answer.
  • Mr. T
    Lv 7
    1 decade ago

    =IF(A1<=200,A1*0.3,IF(A1>200,A1*0.2,""))

    ÕÕ

    <

    ~

Still have questions? Get your answers by asking now.