Linking Functions

Y

young engineer

Board Regular
Joined
Mar 3, 2009
Messages
100
<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><TBODY><TR style="HEIGHT: 35.25pt" height=47><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BORDER-BOTTOM: #95b3d7 1pt solid; HEIGHT: 35.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64 height=47>Brix Read UnDiluted</TD><TD class=xl65 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=xl65 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=xl66 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> D E F

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

Hi All
I want to link the frucpurity function to all the other functions mentioned above.
I want the function to look like =frucpurity(D2)(E2)(F2)
rather than:
=Frucpurity(fruc(brixcor(E2)+E2*+SG(E2),F2),brixcor(E2)+E2*+SG(E2)) <!-- / message -->
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
Code: 
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

What is the relation between Frucpurity and SG and, Fruncpurity and brixcor?
 
Upvote 0
<TABLE style="WIDTH: 629pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=838 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=8 width=64><TBODY><TR style="HEIGHT: 46.5pt" height=62><TD class=xl65 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=xl65 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=xl65 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=xl66 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=xl66 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=xl65 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=xl65 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=xl65 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=xl65 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=xl65 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=xl65 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=xl66 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><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Glucose + Sucrose Purity [%]</TD></TR></TBODY></TABLE>
D E F H I J

Brixcorr : =+brixcor(E2)
Brixcorr[f&G] : =+G2+E2
Brix corr2: =H2*J2
Sg: =+SG(E2)
G[g]in 100: =I2-L2
F[g]in 100: =fruc(I2,F2)
G[g] in 25: =K2*5*15/100
F[g]in 25: =L2*5*15/100
Fructose Purity: =Frucpurity(fruc(I2,F2),I2)

Some of the relationship like brixcorr2, G[g] etc were cell calculations and not functions.
 
Upvote 0
I have downloaded fom the link and tried using this programme to post the sheet, but was unsuccessful. I have posted a new thread call Combined Functions trying to explain it some more and with more info. I hope this helps.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
D
  • Question
How to output a dynamic range where the height of the range varies
Replies
0
Views
969
dagda13
D
J
  • Question
macro to Insert one named range at numerous changing rows containing the macro button inserting relative to the position of macro button used
Replies
0
Views
837
jtatt
J
H
  • Question
Excel function to compute Nominal Int Rate where effective Rate is negative
Replies
3
Views
1K
howard
H
A
  • Question
Web Scraping using VBA
Replies
4
Views
9K
atr140
A

Forum statistics

Threads
1,214,593
Messages
6,120,434
Members
448,961
Latest member
nzskater

Share this page

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