Excel formula

Posted on 2011-04-30
Last Modified: 2012-05-11
Workbook A (WOT Growth Tracking 10-11) & Workbook B have tabulated values
the logic I'm trying to get is -
If cell 'DE7' of Workbook A is more than or equal to 1
If cell 'DE7' of Workbook B is more than or equal to 1
the value of 'BI7' from Workbook A to be displayed in Workbook B
Question by:AMITKHER
    LVL 50

    Expert Comment

    by:barry houdini
    Try using OR function like this

    =IF(OR('Worbook A'!DE7>=1,'Worbook B'!DE7>=1),'Worbook A'!BI7>=1,"")

    regards, barry
    LVL 50

    Accepted Solution

    Sorry, should be like this....

    =IF(OR('Worbook A'!DE7>=1,'Worbook B'!DE7>=1),'Worbook A'!BI7,"")


    Author Comment

    thanx barry this worked but unfortunately it was an error on my part to explain the condition required; i hope you can help further

    let me try to explain the data -
    I'm trying to track day-wise sales growth in 2011-2012 over 2010-11, we usually work only weekdays, but sometimes also on Sundays

    Workbook A Sheet Apr contains date-wise sale data of April 2010-11
    Workbook B Sheet Apr contains date-wise sale data of April 2011-12

    I'm trying to do the following -
    the sale figures (even zero if in case it was a Sunday) of a specific date of 2010-11 should be displayed in Workbook B, only when I punch in the sale figures of the corresponding date in 2011-12

    i hope i'm clear :)

    if it helps I can attach one or both Workbooks

    Author Comment

    it's already night at my end so will be back online on Monday, hope to hear from you :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now