Results 1 to 2 of 2

If function

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    Scottsdale, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    If function

    I am trying to create a solar calculator using the utility company's energy rates.

    The utility company charges $0.05 for the first 400 kWh, plus
    $0.09 for the next 400 kWh (401-800), plus
    $0.11 for the next 2200 kWh (801-3000), plus
    $0.12 for all additional kWh

    How do I calibrate the "IF" function if the value falls between a range?

    I have four columns on my excelsheet

    One column for 0-400kWh
    A second for 401-800kWh
    A third for 801-3000kWh
    and a fourth for 3001+

    (note: I am using the following function for my first column "=IF(Y26>400, $F$8*400, $F$8*Y26)" (whereby Y26 is kWh usage and $F$8=rate)

    I will add up the sum of the columns to get the total cost.

    Please advise.
    Last edited by rickyes; 09-23-2010 at 05:41 PM.

Thread Information

Users Browsing this Thread

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

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