calculate only once

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589
Lets say cell C1 is the result of a condition, say =if(H1=1,1,0) I want Cell C2 to look at the value of Cell B4 as soon as C1 = 1 (note, as soon as C1=1 it won't change any more). Cell C2 will then = this value, but only on this occasion. Cell B4 will change its value, but I do not want cell C2 to update. In plain language, I want C2 to take a freeze of B4 when C1 becomes 1

Confusing :)

Thanks
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,595
Hi there
You could try this event macro:

Right click your sheet tab, left click View Code and paste this in the white area

Private Sub Worksheet_Change(ByVal Target As Range)
If [C1] = 1 Then [C2].Formula = [C2].Value
End Sub

This should convert C2 to a permanent value when C1 equals 1

You will need a formula like this in C2
=IF(C1=1,B4,"")


regards
Derek
This message was edited by Derek on 2002-10-14 23:11
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,595
Hi again
link tells me it is unavailable
What was the question?
regards
Derek
 

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589
On 2002-10-14 23:47, Derek wrote:
Hi again
link tells me it is unavailable
What was the question?
regards
Derek

Whoops,

External Data - Macro Question

Cheers from Western Oz
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,595
Hi again
External Data - Macro Question??????
Not sure I follow you, can you rephrase your question.
regards
Derek
 

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589
Sorry Derek, I was pointing you to the subject line of my question. It is probably on page 2 now, and it would be easier for you to track it down, than for me to re do the Q :)
 

Forum statistics

Threads
1,182,126
Messages
5,933,795
Members
436,912
Latest member
David patrick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top