If statement or Macro?

T

tygrl510

Board Regular
Joined
Feb 9, 2009
Messages
54
I have a spreadsheet that I need to use to invoice a hospital. It's more of a patient tracker. In the file, each patient is paid a certain amount if they reach a certain part of the clinical trial (ie. follow-up appointments). I need the sheet to sum the cost based on the dates entered as their followup.

Can anyone help in either creating a formula? or macro? I thought about having 2 columns for each Follow-up category. Not sure that is the best way.

Thanks in advance!!

******** ******************** ************************************************************************><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0);" colspan="12" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - Invoice Template.xlsx</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 12.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="12" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb658016"><input *******="window.clipboardData.setData("Text",document.formFb431795.sltNb305190.value);" value="Copy Formula" name="btCb074442" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0);" colspan="12" bgcolor="white"><table border="0"><tbody><tr><form name="formFb431795"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value" name="sltNb305190"><option value="=SUM(M5:U5)" selected="selected">K5</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="=SUM(M5:U5)" name="txbFb428726"></td></tr></tbody></table></td></tr><tr><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>K</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>3</center></td><td style="border: 1.5pt solid rgb(0, 0, 0); font-size: 12pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">Patient ID</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">Baseline</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">30 Days FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">3 Months FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">6 Months FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">12 Months FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">2 Years FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">3 Years FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">4 Years FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">5 Years FUP</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); border-top: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">Total</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>4</center></td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 12pt; vertical-align: bottom; border-left: 1.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£100</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£0</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£0</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£0</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£100</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£50</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£50</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£50</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£50</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£2,350</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>5</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">BR43-001</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">1-Jan-2010</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£100</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>6</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">BR43-002</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">10-Feb-2009</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">10-Feb-2010</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">£200</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>7</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">BR43-003</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>8</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">BR43-004</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>9</center></td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; border-left: 0.5pt solid rgb(0, 0, 0); color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">BR43-005</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(192, 192, 192); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td><td style="border-right: 1.5pt solid rgb(0, 0, 0); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); border-bottom: 1.5pt solid rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: center;">
</td></tr><tr><td style="border-width: 0.5pt; border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); background-color: rgb(212, 208, 200);" colspan="12"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-width: 0.5pt; border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); width: 120pt; background-color: rgb(255, 255, 255);" align="left">BR43</td><td>
</td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
for all of us, non-doctors, in here - can you post a sample of what the result should look like?
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
902
gvsumich
G
E
  • Question
Adding a custom message.
Replies
1
Views
491
Micron
M
k3yn0t3
  • Solved
INDEX(MATCH()) pulling wrong row data & Macro to duplicate sheets with formulas
Replies
4
Views
431
Alex Blakenburg
A
R
  • Question
Macro not working after adding two new items
Replies
5
Views
232
regan_2000
R
V
  • Solved
How to put a space in this table in VBA?
Replies
1
Views
366
VBAEXCELNew
V

Forum statistics

Threads
1,216,825
Messages
6,132,940
Members
449,769
Latest member
jorgemarmo

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