Save result of IF function

[Rebbeca]

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
try anyway.
I can set up an IF formula in C5 to sen
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" tha
result in C5 even when the contents of A5 & B5 change. Because the
there is another IF formula in D6 to send the new contents of B5 to D
if the new date in A5 matches the date in E6.
Any help in this matter is appriciated.

Beck

 

[Bernard Liengme]

You cannot do that with a formula, you will need VBA
best wishes

 

[Rebbeca]

Thanks Bernard

You cannot do that with a formula, you will need VB
best wishe
-
Bernard V Liengm
Microsoft Excel MV
'Bernard Liengme' (http://people.stfx.ca/bliengme
remove caps from emai



(http://www.thecodecage.com/forumz/showthread.php?t=64708

 

[Simon Lloyd]

Thanks Bernard.Rebecca, could you attach a sample workbook and i will help you directl

with that

Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
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 troubl
please use this link or the one at the bottom of th
any page

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Rebbeca]

Rebecca, could you attach a sample workbook and i will help you directl
with that

Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
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 troubl
please use this link or the one at the bottom of th
any page.

::Hi Simon,:
::Hope I have done this correct. Find enclosed the work sheets that
am constructing. I don’t know if it will make any difference, but I wil
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] tel
you how much power you are using and estimating how big your eventua
power bills will be.:
::As you will see it is all pretty basic stuff but it is how I teac
myself to use ‘Excel’:
::I am obviously now moving into new territory i.e. VBA so I am reall
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
+-------------------------------------------------------------------

 

[Pecoflyer]

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
spreadsheet as they are nothing but trouble if you need to use the
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 coul
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 ca
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 woul
recommend is to get rid of the merged cells.

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

Hope these considerations are helpful for your future projects :

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[Rebbeca]

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