Then I could use it in a formula like I’ve done in cell C1 below: For constants - instead of referencing a cell for my FX rate, I could simply assign the rate to the name like so (see ‘refers to’ field below):.I can even use that named formula in another formula! That’s a lesson for another day. I can then reference that name in a cell instead of inserting the formula, as you can see below in cell C9: Which will give me the sum of G4:G17 * the FX rate in cell C3, which is $1723.61. For formulas - I can define a name for a formula, for example I could combine my fx_rate name and my US_Sales name in a new name called US_Sales_AUD like so:.I can then use that name in a formula like I’ve done below in cell G1, which sums cells G4:G17 by referring to the named range US_Sales: For ranges - for example I’ve given cells G4:G17 the name US_Sales:.I can then use that name in a formula instead of the cell reference as you can see in the formula bar below for cell C6: For cells - for example cell C3 has the name fx_rate which you can see in the name box (to the left of the formula bar):.
There are 4 types of Named Ranges you can create: xlsx file please ensure your browser doesn't change the file extension on download.
0 kommentar(er)
