PDA

View Full Version : Solved: subtract two formula



Pete
06-25-2008, 04:48 AM
Hi Experts

Need to subtract the following to formula so that Pricing Supply - Pricing Demand

here is the code snippet.



"=((" & _
"'Pricing Supply'!$F" & startrow + 1 & " * " & Chr(10) & _
"(Shipping UFC'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")" -
"=((" & _
"'Pricing Demand'!$F" & startrow + 1 & " * " & Chr(10) & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")"

Bob Phillips
06-25-2008, 04:58 AM
"=((" & _
"'Pricing Supply'!$F" & startrow + 1 & " * " & Chr(10) & _
"(Shipping UFC'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")-" & _
"((" & _
"'Pricing Demand'!$F" & startrow + 1 & " * " & Chr(10) & _
"(1-'Shipping BOG'!$F" & startrow + 1 & "))" & Chr(10) & _
"*" & Chr(10) & _
"'Modelling (Vol)'!$F" & startrow + 1 & ")"

Pete
06-25-2008, 05:01 AM
Thanks.....silly me works a treat. for the feedback.