# calculate only once

#### The Idea Dude

##### Well-known Member
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
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
Hi again
link tells me it is unavailable
What was the question?
regards
Derek

#### The Idea Dude

##### Well-known Member
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
Hi again
External Data - Macro Question??????
regards
Derek

#### The Idea Dude

##### Well-known Member
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

Replies
4
Views
1K
Replies
0
Views
390
Replies
0
Views
438
Replies
4
Views
368
Replies
3
Views
241

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.

### Which adblocker are you using?

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

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