Heron’s Formula Approximately 31 Points Heron, also known as the Hero of Alexandria, was a Greek…


Heron's Formula Approximately 31 Points Heron, so disclosed as the Hero of Alexandria, was a Greek mathematician and engineer who was free in his exported city of Alexandria, Roman Egypt. He is considered the highest experimenter of date, and is disclosed today for his frameula to compute the area of any triangle in provisions of the diffusiveness of its three edges a, b, and c, using the subjoined equations: s = 0.5 * (a + b + c) Area = VS*(s -a) * (s -b)*(s - c) For pattern, a triangle after a while edge diffusiveness of 12, 35, and 37 would yield: s = 0.5 * (12 + 35 +37) = 42 Area = 42* (42 - 12) * (42 - 35) * (42 - 37) = 210 Given any three edge diffusivenesss, the subjoined stipulations must be met for the triangle to be operative: a+b> C b +ca C+a>b On the worksheet designated "Heron's Formula", make an input area after a while three input cells for triangle edge diffusivenesss a, b, and c, which can be any floating-point values. Make an output cell for the triangle area. Clearly dedicate the input/output cells, and furnish them meaningful file names. Make a Main Sub act that uses Heron's Formula to compute the area of a triangle. Your Sub act is expected to do the subjoined, in this order: 1. Read the triangle edge diffusiveness inputs from the worksheet input cells into persomal act changeables. 2. Check that the inputs frame a operative triangle. If not, use a MsgBox to warn the user after a while this message: "Error: The input edge diffusivenesss do not frame a operative triangle", and egress the program. 3. For operative inputs, compute the triangle area, and provision the fruit in a persomal act changeable. 4. Write the fruiting triangle area to the output cell. Make a printable "Run" molehill on the worksheet that obtain run your Sub, and stipulate terse user instructions on the worksheet. Test your Sub for the subjoined cases, and annals the fruits in the steadfast Word document: 1. a = 3, b = 4, c = 5 2. a = 15.1, b = 27.5, and c =35.3 3. a = 5.6, b = 27.0, and c =15.7