Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Excel formula

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
  • 2
  • 2
1 Solution
barry houdiniCommented:
Try using OR function like this

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

regards, barry
barry houdiniCommented:
Sorry, should be like this....

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

AMITKHERAuthor Commented:
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
AMITKHERAuthor Commented:
it's already night at my end so will be back online on Monday, hope to hear from you :)

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now