gg-2 - 'Declare variables B = Range("B2").Value...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Start Let B = Killograms of Bixar br = Killograms of brenine C = Killograms of Colidon Z = Liters of Zimax FP1 - 1 Bixar Production Mix VBA Solution Input B Compute br = .4 * B C = .8 * B Z = B ^ .6 Output (B), br, C, Z End Sub Calc() Dim B, br, C, Z As Double
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 'Declare variables B = Range("B2").Value 'Obtain input br = 0.4 * B 'Calculate values c = 0.8 * B z = B ^ 0.6 Range("B5").Value = br 'Output results to cells Range("B6").Value = c Range("B7").Value = z End Sub Rev: 3/22/10 dd...
View Full Document

This note was uploaded on 04/07/2011 for the course ISYS 200 taught by Professor Dean during the Winter '11 term at BYU.

Ask a homework question - tutors are online