+ Reply to Thread
Results 1 to 4 of 4

Multiple IF Statements w/ Changing Conditions - Need Help!

  1. #1
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Question Multiple IF Statements w/ Changing Conditions - Need Help!

    Hello,

    So I'm trying to build a buy/lease analysis model for cars, and in that model I am including the estimated cost of gasoline,

    I have two tabs, one with the inputs on average price of gasoline for several states (diesel and regular) and the other tab with the formulas for calculating the cost,

    My trouble is building an equation that will display the cost of gasoline in a cell based on two conditions that may change from a drop-down list.

    I assume this would be a VLOOKUP, but I am unsure.

    Any help would be greatly appreciated.

    I've attached an example spreadsheet that may better explain my problem.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Multiple IF Statements w/ Changing Conditions - Need Help!

    Please read the yellow banner at the top of this page on how to attach a file
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    72

    Re: Multiple IF Statements w/ Changing Conditions - Need Help!

    File should be attached.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Multiple IF Statements w/ Changing Conditions - Need Help!

    Please paste the following into cell D7:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Conditions with If Statements in VBA
    By GSU1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-22-2016, 12:08 PM
  2. [SOLVED] Syntax for formula that uses multiple conditions inside of multiple IF statements
    By njmiller31 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 11:55 AM
  3. multiple if statements/conditions syntax
    By kamelkid2 in forum Excel General
    Replies: 3
    Last Post: 01-13-2011, 10:18 AM
  4. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  5. Multiple conditions in nested IF statements
    By havfunonline2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2009, 05:36 AM
  6. If statements with multiple conditions
    By afathi in forum Excel General
    Replies: 4
    Last Post: 04-22-2008, 04:30 PM
  7. IF Statements, Multiple Conditions
    By DiamondCutter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2005, 11:25 PM

Tags for this Thread

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