Utilization of Microsoft Office 2007 to create "What If" amortization tables.

This file contains a formatted MS Excel spreadsheet containing "What IF" amortization tables for determination of the "best" bank loan.

An Excel "If And" Spreadsheet

Please see the attached.....it is an advanced material balance model I am working on but I need help in one area to complete it. I am trying to accomplish the following --- so if you look at my attached document: In Cell K13, I want a calculated value based on the following: If the Product Code entered in Cell G5 is "A", then I want the formula for cell K13 to be: (I5*4.1667*60)/1000)/60*D5*.015 If the Product Code entered in Cell G5 is "B", then I want the formula for cell K13 to be: (I5*4.1667*60)/1000)/60*D6*.015 I presently have a formula in cell K13 but please ignore....I want it to be as I've described above. How can this be written and I presume it is an "IF AND" typ... click for more

Find the 8-bit two's complement representation of -24

Find the 8-bit two's complement representation of -24 please do it in the next 10 minutes

Apply twice around algorithm to traveling salesman problem

How do you apply the "twice around" algorithm to the each of the 6 points (in the attached file). Please make the steps clear.

Apply Christofides algorithm to traveling salesman problem

How do you apply the "Christofides" algorithm to the each of the 6 points (in the attached file). Please make the steps clear.