inputting formulas into a spreadhseet using other formulas and constants

  • Thread starter Thread starter fruvous333
  • Start date Start date
F

fruvous333

i wish to program into a spreadsheet a formula that will be solved b
using the results of many smaller formulas and constants

ie Qh = hc(ts-ta)
and hc = 2.84(.00033u)
u = 4 m/s
ta assumed to be 290
ts assumed to be 300

how would i do this

also will excel automatically use constants that are on the sprea
sheed and part of the larger formula
 
You could add workbook names that have values rather than references. For
instance

goto menu Insert>Name>Define...
in Names for Workbook, put say ta
in Refers to, put =290
OK

Repeat for other values (ts, u) and then repeat for
a name value of hc with a RefersTo value of =2.84*(0.00033*u), aand
a name value of Qc witha RefersTo value = hc*(ts-ta)

All of the names can be used in a formula

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top