Solved

# Excel formula

Posted on 2011-04-30
193 Views
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
Question by:AMITKHER

LVL 50

Expert Comment

Try using OR function like this

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

regards, barry
0

LVL 50

Accepted Solution

Sorry, should be like this....

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

barry
0

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
0

Author Comment

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

## Featured Post

### 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…