Combining Functions

young engineer

Board Regular
Joined
Mar 3, 2009
Messages
100
<TABLE style="WIDTH: 581pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=774 border=0><COLGROUP><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=4 width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 46.5pt" height=62><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; HEIGHT: 46.5pt; BACKGROUND-COLOR: transparent" width=64 height=62>Brix Read UnDiluted</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brix Read Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Angle Diluted solution</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brixcorr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 53pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=70>Brixxcorr [F &G]</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brix Corr 2 [g/cm3]</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>SG</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>G[g] in 100cm3 Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>F[g] in 100 cm3 Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>G[g] in 25cm3</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>F[g] in 25cm3</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Fructose Purity [%]</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: #dbe5f1" height=20>0.1</TD><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #dbe5f1">0.02</TD><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #dbe5f1">0.01</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl68 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.02</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">1.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> 19.23 </TD></TR></TBODY></TABLE>

Function brixcor(Brix As Double)
A = 0.006222
B = 0.00023725
C = -0.0000018165
D = 0.000000018906
E = 0.00002328
brixcor = A * Brix + B * Brix ^ 2 + C * Brix ^ 3 + D * Brix ^ 4 + E * Brix ^ 2
End Function

Function SG(dil)
SG = 1 + [(dil ^ 2 + 200 * dil) / 54000]
End Function

Function fruc(bxcorr2, angle1)
A = 52.5
B = 143.8
C = 50
fruc = ((A * bxcorr2) / B) - ((C * angle1) / B)
End Function

Function Frucpurity(fruc, bxcorr2)
Frucpurity = (fruc / bxcorr2) * 100
End Function


Brixcorr F&G: H2+F2
Brixcorr2: I2*K2
G[g]in 100: J2-M2
G[g]in25cm: L2*5*25/100
F[g]in25cm: M2*5*25/100


Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))


Required:
Frucpurity(D2)(E2)(F2)


Hi All
I have calculated the fructose purity in the last cell using a combination of functions and cell based calculations. I have listed all the functions used aswell as the cell based calculations. The fructose purity now only uses the blue shaded entries for the final answer. the final equation for the fructose purity is
Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))
but i would like to link my frucpuity function to all the other functions and the cells so that my final fructose equation is simply a single function with 3 variables like
Frucpurity(D2)(E2)(F2)

Please help
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
I am strugglig to line up your data with the results. Which column aligns to the headings you use?
 
Upvote 0
<TABLE style="WIDTH: 581pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=774 border=0><TBODY><TR style="HEIGHT: 46.5pt" height=62><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; HEIGHT: 46.5pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64 height=62>Brix Read UnDiluted</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>Brix Read Diluted solution</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>Angle Diluted solution</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>Brixcorr</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 53pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=70>Brixxcorr [F &G]</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>Brix Corr 2 [g/cm3]</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>SG</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>G[g] in 100cm3 Diluted solution</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>F[g] in 100 cm3 Diluted solution</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>G[g] in 25cm3</TD><TD class=xl63 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>F[g] in 25cm3</TD><TD class=xl64 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>Fructose Purity [%</TD></TR></TBODY></TABLE>

Column

Brix Read Undiluted E
Brix Read Diluted F
Angle Diluted Sol G
Brixcorr H
Brixcorr[F&G] I
Brixcorr 2 J
SG K
G[g] in 100cm L
F[g]in 100cm M
G[g]in 25cm N
F[g]in 25cm O
Fructose purity P
 
Upvote 0
Sorry, I can't get this anywhere near the results that you get, and it is crashing my Excel, so unless you can post the workbook somewhere I will have to pass.
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top