How to copy value from a cell in google sheets?

Hello!
3 hours sitting scratching their heads, Google, but can not find anything.
In cell A1 have the actual dollar, which is taken from the website of the Ministry of Finance automatically.
The value from cell A1 copied into Cell B1 the formula (=A1).
Then comes the calculation, for example:
A1 = 25 C1=2($)
D1= C1(2$) * B1(25 UAH) = 50 UAH, we had the purchase price in dollars and we have translated it in the hryvnia.
But there is one big BUT, if you change the rate in cell A1 then change all the calculations.
Is there any formula like (=A1) that would only value not equal to and copied from the cell and remained static.
How to make so that the value is copied from cell A1 and remained static? That is, if A1 changes, B1 will remain unchanged.
I hope I asked the question, because the head is a mess and difficult to articulate.
Thank you all for the answers.
April 4th 20 at 00:42
2 answers
April 4th 20 at 00:44
Copy A1 to the clipboard and then paste them into B1 as Edit->Paste special->Paste values only.
Manually is too much and long
Thanks for the reply, but it's not what you need) - gregoria_Kemmer commented on April 4th 20 at 00:47
@gregoria_Kemmer, so usually it looks like this: A1 A1000...we have some values in B1 write the formula and copy it to B2 B1000...(you can also use ArrayFormula), then select the entire column B and copy as values in C. - maryjane.Goodwin16 commented on April 4th 20 at 00:50
@gregoria_Kemmer, I reread the question and thought for a moment, I believe, in this case speech can go about the script (macro) that will be invoked upon request and, for example, to generate a new line.

For example, in A1, time in B1 course, the script searches for a free line, and writes in An time in the Bn course (as a value, not formula) to other cells of the row, you can write formulas that of Bn think all that is needed. - maryjane.Goodwin16 commented on April 4th 20 at 00:53
April 4th 20 at 00:46
If you want to fix the exchange rate on a certain date, use the function GOOGLEFINANCE(code [attribute]; [dataname]; [datacontainer|days]; [interval])
Information about the function in Russian
For example, in A1 write (instead of USD and RUB, you can substitute any other currency):
=GoogleFinance("CURRENCY:USDRUB"; "close"; D2)
In D2 , write the date of purchase. And the currency pulled up from a certain date. Since this is historical data, they will not change.
Super!
And another question, how to do the formula just given out the course, with no Date column?
5e11a80a60444854161242.png - gregoria_Kemmer commented on April 4th 20 at 00:49
I would make a function in JS, but it is possible without code, like so:
=filter(filter(GoogleFinance("CURRENCY:USDRUB"; "close"; D2);{0;1});{0\1})

If you're interested how it works:
Function GoogleFinance() fails with 4 cells (2x2), for convenience we write as
╔═══╦═══╗
║ 1 ║ 2 ║
supply ═══╬═══µ
║ 3 ║ 4 ║
╚═══╩═══╝

1) inner FILTER() cuts off the first line by the condition {0;1}
0 - do not display the first row
1 - display the second
; - string delimiter
Remains
╔═══╦═══╗
║ 3 ║ 4 ║
╚═══╩═══╝

2) external FILTER() with the condition {0\1} from the string only selects the second cell.
0 - do not display the first row
1 - display the second
\ - go to the next cell in the row
Remains
╔═══╗
║ 4 ║
╚═══╝
- Colin_Fadel77 commented on April 4th 20 at 00:52

Find more questions by tags Google Sheets