+ Reply to Thread
Results 1 to 6 of 6

multiple if formulas

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    60

    Post multiple if formulas

    Hi,

    Need help for using multiple if condition.

    Currently I have 2 tabs in excel sheet 1st is Maintenance Bill & 2nd is Maintenance Due.

    I need to write below condition example:-

    *FROM Maintenance Bill TAB*

    If FLAT NO = A - 101 (ANY SELECTED FLAT NUMBER FROM THE DROP DOWN)

    AND

    PERIOD = MARCH 2020 (ANY SELECTED MONTHS FROM THE DROP DOWN)

    AND

    PREVIOUS MONTH = DUE

    THEN

    IN - 2nd Maintenance Due TAB

    FOR FLAT NO - A - 101 ROW - February-20 column should shown Rs 3000


    OR

    PREVIOUS MONTH = PAID

    IN - 2nd Maintenance Due TAB

    FOR FLAT NO - A - 101 ROW - February-20 column should shown Rs 0

    Attached excel for reference.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 03-12-2020 at 03:33 AM. Reason: Please keep title to the point

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016
    Posts
    712

    Re: multiple if formulas

    I think this formula covers the question, to put in cell F6 ( and copy the rest ) in your TAB/worksheet "Maintenance Due":
    Please Login or Register  to view this content.
    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,424

    Re: multiple if formulas

    I think the above answers what is asked, but I imagine the values need to stay on the maintenance due tab, when another bill is to be printed, and they will disappear.

    I can not see the point of the formula, and how in the real world it would help Sharbazk. this is more a reflection on the question not the answer!

    I could see the formula becoming a value and staying there (although a VBA approach is likely) until it had been paid, but with a formula it will just disappear

  4. #4
    Registered User
    Join Date
    08-18-2017
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: multiple if formulas

    Thanks for your help.

    But the values are getting disappeared when selected another flat number. it should not get override.

    Can you please help me with that

  5. #5
    Registered User
    Join Date
    08-18-2017
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    60

    Re: multiple if formulas

    Thanks Davsth,

    You are right !!!

  6. #6
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    2,424

    Re: multiple if formulas

    The question is when are you going to populate information and where

    if you directly entered the information on the background sheet, you could pull it into the invoice

    But with regards to overwriting existing values or writing to the sheet with vba Im not sure you have explained how you wish it to work

    currently you would match the month and the flat


    something like this to keep it simple for you
    in o7 =IF($K$11>0,MATCH(G6,'Maintenance Due'!5:5,0),"")
    in o8 =IF($K$11>0,MATCH(D7,'Maintenance Due'!A:A,0),"")


    then some code to update value in due sheet, attach to a button
    Please Login or Register  to view this content.
    you clikc the button and it updates the background sheet. save as xlsm

+ 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. Replies: 4
    Last Post: 10-19-2016, 02:45 PM
  2. Replies: 1
    Last Post: 06-03-2015, 06:27 PM
  3. formulas for search based on multiple criteria in multiple columns
    By oneworld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 06:57 AM
  4. Replies: 0
    Last Post: 04-14-2013, 08:39 PM
  5. Multiple formulas in selected cell without damaging previous formulas.
    By excel5111987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2011, 06:15 AM
  6. Copy formulas to adjacent columns - multiple cells and multiple sheets
    By swanseaexcel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-12-2011, 06:21 AM
  7. Sort multiple columns with multiple formulas without returning #R
    By bellsjrb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2006, 05:05 AM

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