The FV() function.
The Average function. For example, to get the mean of the cells from A2 to A15, you would use it this way: =AVERAGE(A2:A15)
You would use the SECOND function on the NOW function, like this: =SECOND( NOW() )
Prices fluctuate daily. Current, without a date, is not helpful. This question may be read a year from now. Or more. Giving 'todays' price would not apply.
The SUM function.
You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:=MEDIAN(A2:D50)
Depending on the current gold market as of today Friday June 17th, 2011. A gold bar (1oz in weight)at todays prices would be worth $1613.41. Though in saying that the prices could rise or fall, with todays market it will definitely rise and the price will rise. This is good if you own gold.
Roughly 45,000 to 50,000 given the current rate of inflation.
The TODAY function returns the current date when the function is executed. That would be when you open the document or when you insert the function for the first time in a cell.
sum
the inverse would be 74.95-1 this would make it 1/74.95 to check yourself, this would be equal to 0.013342
In todays exchange rate (June 29 2008) it would be 79.28 poundsAbout 88 GBP.