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

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 232

# 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
OR
If cell 'DE7' of Workbook B is more than or equal to 1
then
the value of 'BI7' from Workbook A to be displayed in Workbook B
0
AMITKHER
• 2
• 2
1 Solution

Commented:
Try using OR function like this

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

regards, barry
0

Commented:
Sorry, should be like this....

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

barry
0

Author 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
0

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

## Featured Post

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