Help value cell format

azn · Jun 20, 2011

Hi
can someone please help me with getting the right formula.i am trying to use Excel for creating invoice. there were 4 column all together, 1 is date and 2 & 3 were type of product and 4 is the price.

situation is i need to cell c value to be either $165 or $135 depend on the type word enter into cell a and b.
so if a were enter WHITEPAPER then cell c value is $165 and if cell b enter cardboard then cell c value would be $135.

any suggest that can make it easier please do let me know.

Thanks you

Sektor · Jun 20, 2011

I guess, there can be only one value: either in A or B column. Correct?

repairman615 · Jun 20, 2011

Hello,

This may not be the best way, yet it will not allow both or an empty:

<TABLE style="WIDTH: 639pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=852><COLGROUP><COL style="WIDTH: 639pt; mso-width-source: userset; mso-width-alt: 15579" width=852><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 639pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=852>=IF(AND(A1="",B1=""),"No Entry",IF(AND(A1="WhitePaper",B1=""),165,IF(AND(B1="Cardboard",A1=""),135,"Choose One")))</TD></TR></TBODY></TABLE>

azn · Jun 20, 2011

i try use the formula it not working, please help

repairman615 · Jun 20, 2011

Sure,

The table below shows the locations of the data starting in row 1
Column C has the formulas results down to row 10.

you may need to change the cell references.

If you could tell me which row you need this in, I will help to modify.

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD>WHITEPAPER</TD><TD style="BORDER-RIGHT: black 1px solid">cardboard</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Choose One</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD>cardboard</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid">135</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right"></TD><TD>cardboard</TD><TD style="TEXT-ALIGN: right">135</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right"></TD><TD>cardboard</TD><TD style="TEXT-ALIGN: right">135</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD>Whitepaper</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">165</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD>Whitepaper</TD><TD>cardboard</TD><TD>Choose One</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>No Entry</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD>No Entry</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right"></TD><TD>cardboard</TD><TD style="TEXT-ALIGN: right">135</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD>Whitepaper</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right">165</TD></TR></TBODY></TABLE>

Sheet1

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C1</TH><TD style="TEXT-ALIGN: left">=IF(AND(A1="",B1=""),"No Entry",IF(AND(A1="WhitePaper",B1=""),165,IF(AND(B1="Cardboard",A1=""),135,"Choose One")))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

azn · Jun 20, 2011

what if i use only 1 column for type of material
like value of cell C4 is $165 if cell B4 is whitepaper,and cell C4 value is $135 if cell B4 is cardboard.

will this work?

repairman615 · Jun 20, 2011

Another look with all formulas:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">WHITEPAPER</td><td style="border-right: 1px solid black;;">cardboard</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #EAF1DD;;"> Choose One </td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td><td style=";">cardboard</td><td style="text-align: right;border-top: 1px solid black;;"> $ 135.00 </td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style=";">cardboard</td><td style="text-align: right;;"> $ 135.00 </td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style=";">cardboard</td><td style="text-align: right;;"> $ 135.00 </td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Whitepaper</td><td style="text-align: right;;"></td><td style="text-align: right;;"> $ 165.00 </td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Whitepaper</td><td style=";">cardboard</td><td style=";"> Choose One </td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"> No Entry </td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";"> No Entry </td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style=";">cardboard</td><td style="text-align: right;;"> $ 135.00 </td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Whitepaper</td><td style="text-align: right;;"></td><td style="text-align: right;;"> $ 165.00 </td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C1</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A1="",B1=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A1="WhitePaper",B1=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B1="Cardboard",A1=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C2</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A2="",B2=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A2="WhitePaper",B2=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B2="Cardboard",A2=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C3</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A3="",B3=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A3="WhitePaper",B3=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B3="Cardboard",A3=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C4</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A4="",B4=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A4="WhitePaper",B4=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B4="Cardboard",A4=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C5</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A5="",B5=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A5="WhitePaper",B5=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B5="Cardboard",A5=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C6</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A6="",B6=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A6="WhitePaper",B6=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B6="Cardboard",A6=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C7</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A7="",B7=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A7="WhitePaper",B7=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B7="Cardboard",A7=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C8</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A8="",B8=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A8="WhitePaper",B8=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B8="Cardboard",A8=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C9</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A9="",B9=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A9="WhitePaper",B9=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B9="Cardboard",A9=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C10</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">A10="",B10=""</font>),"No Entry",IF(<font color="Red">AND(<font color="Green">A10="WhitePaper",B10=""</font>),165,IF(<font color="Green">AND(<font color="Purple">B10="Cardboard",A10=""</font>),135,"Choose One"</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

repairman615 · Jun 20, 2011

That would be better in my opinion to use 1 column.

I will post another formula.

Please tell me the row number.

Jeff

repairman615 · Jun 20, 2011

This will produce dashes if the cell in column B is blank:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>B</TH><TH>C</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="BORDER-RIGHT: black 1px solid">cardboard</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 135.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="BORDER-RIGHT: black 1px solid">WhitePaper</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 165.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="BORDER-RIGHT: black 1px solid">cardboard</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 135.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">--- </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="BORDER-RIGHT: black 1px solid">WhitePaper</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 165.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="BORDER-RIGHT: black 1px solid">cardboard</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 135.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">--- </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">--- </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BORDER-RIGHT: black 1px solid">cardboard</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 135.00 </TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BORDER-RIGHT: black 1px solid">WhitePaper</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #eaf1dd; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">$ 165.00 </TD></TR></TBODY></TABLE>

Sheet1

<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C1</TH><TD style="TEXT-ALIGN: left">=IF(B1="","---",IF(B1="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C2</TH><TD style="TEXT-ALIGN: left">=IF(B2="","---",IF(B2="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C3</TH><TD style="TEXT-ALIGN: left">=IF(B3="","---",IF(B3="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C4</TH><TD style="TEXT-ALIGN: left">=IF(B4="","---",IF(B4="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C5</TH><TD style="TEXT-ALIGN: left">=IF(B5="","---",IF(B5="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C6</TH><TD style="TEXT-ALIGN: left">=IF(B6="","---",IF(B6="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C7</TH><TD style="TEXT-ALIGN: left">=IF(B7="","---",IF(B7="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C8</TH><TD style="TEXT-ALIGN: left">=IF(B8="","---",IF(B8="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C9</TH><TD style="TEXT-ALIGN: left">=IF(B9="","---",IF(B9="WHITEPAPER",165,135))</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>C10</TH><TD style="TEXT-ALIGN: left">=IF(B10="","---",IF(B10="WHITEPAPER",165,135))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

azn · Jun 20, 2011

hi
the invoice is similar to below table
 <table class="MsoTableGrid" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext" border="1" cellpadding="0" cellspacing="0"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes"> <td style="width:73.8pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt" valign="top" width="98">

A