Save result of IF function

3 A B C D E
4 Date Number Result 1 Result 2 Date
5 15/02/2009 1345.5 15/02/2009
6 16/02/2009

Hi, Don't know if this makes any sense to anybody but I'll give it a
try anyway.
I can set up an IF formula in C5 to send
contents of B5 to C5 if the date in A5matches the date in E5.
My problem is:-
How or what do I have to do to the formula to be able to "Save" that
result in C5 even when the contents of A5 & B5 change. Because then
there is another IF formula in D6 to send the new contents of B5 to D6
if the new date in A5 matches the date in E6.
Any help in this matter is appriciated.

Becky


--
Rebbeca
------------------------------------------------------------------------
Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

You cannot do that with a formula, you will need VBA
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rebbeca" wrote in message
...

3 A B C D E
4 Date Number Result 1 Result 2 Date
5 15/02/2009 1345.5 15/02/2009
6 16/02/2009

Hi, Don't know if this makes any sense to anybody but I'll give it a
try anyway.
I can set up an IF formula in C5 to send
contents of B5 to C5 if the date in A5matches the date in E5.
My problem is:-
How or what do I have to do to the formula to be able to "Save" that
result in C5 even when the contents of A5 & B5 change. Because then
there is another IF formula in D6 to send the new contents of B5 to D6
if the new date in A5 matches the date in E6.
Any help in this matter is appriciated.

Becky


--
Rebbeca
------------------------------------------------------------------------
Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

Thanks Bernard.


Bernard Liengme;231728 Wrote:
You cannot do that with a formula, you will need VBA
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
'Bernard Liengme' (http://people.stfx.ca/bliengme)
remove caps from email

"Rebbeca" wrote in message
...

3 A B C D E
4 Date Number Result 1 Result 2 Date
5 15/02/2009 1345.5 15/02/2009
6 16/02/2009

Hi, Don't know if this makes any sense to anybody but I'll give it a
try anyway.
I can set up an IF formula in C5 to send
contents of B5 to C5 if the date in A5matches the date in E5.
My problem is:-
How or what do I have to do to the formula to be able to "Save" that
result in C5 even when the contents of A5 & B5 change. Because then
there is another IF formula in D6 to send the new contents of B5 to
D6
if the new date in A5 matches the date in E6.
Any help in this matter is appriciated.

Becky


--
Rebbeca

------------------------------------------------------------------------
Rebbeca's Profile: 'The Code Cage Forums - View Profile: Rebbeca'
(http://www.thecodecage.com/forumz/member.php?userid=131)
View this thread: 'Save result of IF function - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=64708)



--
Rebbeca

The future belongs to those who believe in the beauty of their own
dreams
------------------------------------------------------------------------
Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

Rebbeca;231781 Wrote:
Thanks Bernard.Rebecca, could you attach a sample workbook and i will help you directly
with that.

Attatchments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attatchments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

Simon Lloyd;231798 Wrote:
Rebecca, could you attach a sample workbook and i will help you directly
with that.

Attatchments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attatchments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.


::Hi Simon,::
::Hope I have done this correct. Find enclosed the work sheets that I
am constructing. I don’t know if it will make any difference, but I will
briefly explain what I am doing.::
::I am putting together a sort of program [if that is the correct word]
for domestic use that will [upon entering meter readings & dates] tell
you how much power you are using and estimating how big your eventual
power bills will be.::
::As you will see it is all pretty basic stuff but it is how I teach
myself to use ‘Excel’::
::I am obviously now moving into new territory i.e. VBA so I am really
looking forward to what you have to say.::
::Many thanks again::
::Becky.::


+-------------------------------------------------------------------+
|Filename: For Simon Electricity & Gas Bill Estimates.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=78|
+-------------------------------------------------------------------+

--
Rebbeca

The future belongs to those who believe in the beauty of their own
dreams
------------------------------------------------------------------------
Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

Hi Rebecca, and welcome to the board,

I had a look at your WB, which looks quite elaborate.

If I may give you a piece of advice, don not use -merged cells- in a
spreadsheet as they are nothing but trouble if you need to use them
later on to analyze your data.

On the other hand, they are OK for cosmetic purposes.

So, in your sheet " Tables MEB" as there is no data yet, you could
change them to normal cells

It's sometimes easier to make a simple list as " database" in XL
Say like 3 columns with titles Date, Period,Readings in which data can
be entered with drop down boxes, etc..or, the often forgotten Data -
List feature

If you feel comfortable with your table as is, the only thing I would
recommend is to get rid of the merged cells.

Also, if you want to make a form, like your first SS, XL has Form
templates or Form elements which make data entry easy, instead of
tabbing from one cell to another or playing around with the mouse.

Hope these considerations are helpful for your future projects


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708

Hi Pecoflyer,
Thanks for your comments. I have taken them on board and am now having
another look at the way I have set out my W/B to see what can be done.
Thanks
BeckyBg


--
Rebbeca

The future belongs to those who believe in the beauty of their own
dreams
------------------------------------------------------------------------
Rebbeca's Profile: http://www.thecodecage.com/forumz/member.php?userid=131
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64708