Solved

Why do functions not work with referred cells

Posted on 2014-11-02
3
120 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 49

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 49

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

810 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