Results 1 to 13 of 13

Using a nested IF Function and AND function on 2 sheets?

Threaded View

heresteve2 Using a nested IF Function... 04-28-2014, 04:41 PM
gak67 Re: Using a nested IF... 04-28-2014, 05:06 PM
Alex H Re: Using a nested IF... 04-28-2014, 05:22 PM
heresteve2 Re: Using a nested IF... 04-28-2014, 05:28 PM
gak67 Re: Using a nested IF... 04-28-2014, 05:33 PM
heresteve2 Re: Using a nested IF... 04-28-2014, 05:39 PM
gak67 Re: Using a nested IF... 04-28-2014, 05:44 PM
Alex H Re: Using a nested IF... 04-28-2014, 05:45 PM
heresteve2 Re: Using a nested IF... 04-28-2014, 05:54 PM
Alex H Re: Using a nested IF... 04-28-2014, 05:59 PM
heresteve2 Re: Using a nested IF... 04-29-2014, 09:25 AM
gak67 Re: Using a nested IF... 04-28-2014, 06:04 PM
Alex H Re: Using a nested IF... 04-29-2014, 02:14 PM
  1. #1
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    138

    Using a nested IF Function and AND function on 2 sheets?

    I am not sure if this is the correct type of formula so I'm looking for some help.

    I attached the workbook so you can see what I am working on.

    Basically what I am trying to do is as follows,

    If Sheet 1 Col B Matches Sheet 2 Col A (Unit Type) I want it to put in Sheet 1 Col F one of two things:

    IF Sheet 1 Col G (Market Rent) Matches Sheet 2 Col E for that Unit Type (Sheet 1 Col B or Sheet 2 Col A) then put Sheet 2 Col G
    IF it does not match for that unit type then I want it to Subtract the Sheet 2 Col E from Sheet 1 Col G (Market Rent) add that to Sheet 2 Col G and return that number in Sheet 1 Col F.

    Figuring out what I am talking about is probably harder that the actual formula so please let me know what clarification will help! I greatly appreciate any efforts on this!
    Attached Files Attached Files
    Last edited by heresteve2; 04-28-2014 at 05:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested Function With Division - Receiving #VALUE! Function Error
    By DDM64 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2013, 01:16 PM
  2. Replies: 6
    Last Post: 12-14-2012, 10:43 PM
  3. [SOLVED] Nested AND function within IF function is only addressing logical1 but not logical2
    By betic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2012, 09:17 AM
  4. Replies: 1
    Last Post: 04-16-2008, 08:45 AM
  5. Offset function with nested match function not finding host ss.
    By MKunert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06:50 PM

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