Solved

Why do functions not work with referred cells

Posted on 2014-11-02
3
116 Views
Last Modified: 2014-11-03
I have an ongoing issue with functions not working in a statement when it is required they use a value from a cell whose value references another cell.
It makes no difference if the reference in text or numeric.
When apply a manually entered version of the cell's contents the formulae work fine but that defeats the exercise of a dynamic solution and is not always possible or desirable
I have attached an example which although simple occurs in more complex statements
Any advice
Referred-values.xlsx
0
Comment
Question by:DAVID131
  • 2
3 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40418025
Hi,
¨
pls try (in B2)

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)


Regards
0
 

Author Comment

by:DAVID131
ID: 40418180
Good Afternoon
Your solution works, however I would like to understand why it works because as I indicated in the original request this is not confined to this particular example -It is important that I do understand why this is happening
David
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40418852
You compared today which was Nov-2-2014 with Nov-1-2014
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

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

17 Experts available now in Live!

Get 1:1 Help Now