Dashboard
PHP:
8.1.34
OS:
Linux
User:
uid288609
/
/
usr
/
share
/
doc
/
libspreadsheet-writeexcel-perl
/
html
📤 Upload
📝 New File
📁 New Folder
Close
Editing: number_formats2.html
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 9"> <link rel=File-List href="./Nmbrfrmt2_files/filelist.xml"> <style id="Nmbrfrmt_21703_Styles"> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .xl1521703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; mso-background-source:auto; mso-pattern:auto; white-space:nowrap;} .xl2221703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; background:white; mso-pattern:auto none; white-space:nowrap;} .xl2321703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; background:white; mso-pattern:auto none; white-space:normal;} .xl2421703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:white; mso-pattern:auto none; white-space:nowrap;} .xl2521703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl2621703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl2721703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl2821703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:"Courier New", monospace; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl2921703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#FF8080; mso-pattern:auto none; white-space:nowrap;} .xl3021703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl3121703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#FF8080; mso-pattern:auto none; white-space:nowrap;} .xl3221703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#FFFFC0; mso-pattern:auto none; white-space:nowrap;} .xl3321703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#FF8080; mso-pattern:auto none; white-space:nowrap;} .xl3421703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:12.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center-across; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#336666; mso-pattern:auto none; white-space:nowrap;} .xl3521703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center-across; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#336666; mso-pattern:auto none; white-space:nowrap;} .xl3621703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center-across; vertical-align:middle; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:#336666; mso-pattern:auto none; white-space:nowrap;} .xl3721703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:teal; mso-pattern:auto none; white-space:nowrap;} .xl3821703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:teal; mso-pattern:auto none; white-space:nowrap;} .xl3921703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:teal; mso-pattern:auto none; white-space:normal;} .xl4021703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:white; font-size:10.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:center; vertical-align:middle; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none; background:teal; mso-pattern:auto none; white-space:normal;} .xl4121703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[>9999999\]\\\(000\\\)000\\-0000\;000\\-0000"; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4221703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[>9999999\]\\\(000\\\)000\\-0000\;000\\-0000"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4321703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[>9999999\]\\\(000\\\)000\\-0000\;000\\-0000"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4421703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<1\]\.00\\�\;\0022$\00220\.00_�"; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4521703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<1\]\.00\\�\;\0022$\00220\.00_�"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4621703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<1\]\.00\\�\;\0022$\00220\.00_�"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4721703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<=2\]\0022Low\0022* 0\;\[>=4\]\0022High\0022* 0\;\0022Average\0022* 0"; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4821703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<=2\]\0022Low\0022* 0\;\[>=4\]\0022High\0022* 0\;\0022Average\0022* 0"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl4921703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[<=2\]\0022Low\0022* 0\;\[>=4\]\0022High\0022* 0\;\0022Average\0022* 0"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl5021703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[Red\]\[<=2\]0\;\[Green\]\[>=4\]0\;\[Black\]0"; text-align:general; vertical-align:bottom; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl5121703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"\[Red\]\[<=2\]0\;\[Green\]\[>=4\]0\;\[Black\]0"; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} .xl5221703 {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext; background:#A6CAF0; mso-pattern:auto none; white-space:nowrap;} --> </style> </head> <body bgcolor="white"> <!--[if !excel]> <![endif]--> <!--The following information was generated by Microsoft Excel's Publish as Web Page wizard.--> <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.--> <!-----------------------------> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --> <!-----------------------------> <div id="Nmbrfrmt_21703" align=center x:publishsource="Excel"> <table x:str border=0 cellpadding=0 cellspacing=0 width=871 style='border-collapse: collapse;table-layout:fixed;width:653pt'> <col width=379 style='mso-width-source:userset;mso-width-alt:16170;width:284pt'> <col width=292 style='mso-width-source:userset;mso-width-alt:12458;width:219pt'> <col width=99 style='mso-width-source:userset;mso-width-alt:4224;width:74pt'> <col width=101 style='mso-width-source:userset;mso-width-alt:4309;width:76pt'> <tr height=32 style='mso-height-source:userset;height:24.0pt'> <td height=32 colspan=4 class=xl3421703 align=center width=871 style='height:24.0pt;border-right:.5pt solid black;width:653pt'>Sample Custom Number Formats</td> </tr> <tr height=68 style='height:51.0pt'> <td height=68 class=xl3721703 style='height:51.0pt;border-top:none'>Format Code</td> <td class=xl3821703 style='border-top:none'>Description</td> <td class=xl3921703 width=99 style='border-top:none;width:74pt'>Data with General Format</td> <td class=xl4021703 width=101 style='border-top:none;width:76pt'>Data with Custom Number Format</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl2221703 style='height:12.75pt'> </td> <td class=xl2221703> </td> <td class=xl2321703 width=99 style='width:74pt'> </td> <td class=xl2321703 width=101 style='width:76pt'> </td> </tr> <tr height=18 style='height:13.5pt'> <td height=18 class=xl2821703 style='height:13.5pt'>[>9999999](000)000-0000;000-0000</td> <td class=xl2521703>Displays a telephone number with or without an</td> <td class=xl2921703 align=right x:num="7045556325">7045556325</td> <td class=xl4121703 align=right style='border-left:none' x:num="7045556325">(704)555-6325</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>area code.</td> <td class=xl3121703 align=right x:num="9106325689">9106325689</td> <td class=xl4221703 align=right style='border-left:none' x:num="9106325689">(910)632-5689</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>If the number is greater than 9,999,999, this code</td> <td class=xl3121703 align=right x:num>8896523</td> <td class=xl4221703 align=right style='border-left:none' x:num="8896523">889-6523</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>displays the number with an area code</td> <td class=xl3121703 align=right x:num>5362563</td> <td class=xl4221703 align=right style='border-left:none' x:num="5362563">536-2563</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>((000)000-0000); otherwise the number appears</td> <td class=xl3121703 align=right x:num="2065896325">2065896325</td> <td class=xl4221703 align=right style='border-left:none' x:num="2065896325">(206)589-6325</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3221703 style='height:12.75pt'> </td> <td class=xl2721703>without the area code (000-0000).</td> <td class=xl3321703 align=right x:num="3369856">3369856</td> <td class=xl4321703 align=right style='border-left:none' x:num="3369856">336-9856</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl2421703 style='height:12.75pt'> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> </tr> <tr height=18 style='height:13.5pt'> <td height=18 class=xl2821703 style='height:13.5pt'>[<1].00�;$0.00_�</td> <td class=xl2521703>Shows currency values in dollars or cents.</td> <td class=xl2921703 align=right x:num>1.25</td> <td class=xl4421703 align=right style='border-left:none' x:num="1.25">$1.25 </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>This code displays values less than 1 in</td> <td class=xl3121703 align=right x:num>3</td> <td class=xl4521703 align=right style='border-left:none' x:num="3">$3.00 </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>cents notation (.00�), and display values</td> <td class=xl3121703 align=right x:num="00.35">0.35</td> <td class=xl4521703 align=right style='border-left:none' x:num="00.35">.35�</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>greater than or equal to 1 in dollars, and</td> <td class=xl3121703 align=right x:num="00.95">0.95</td> <td class=xl4521703 align=right style='border-left:none' x:num="00.95">.95�</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703>leaves a space on the right so that the</td> <td class=xl3121703 align=right x:num>22.36</td> <td class=xl4521703 align=right style='border-left:none' x:num="22.36">$22.36 </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3221703 style='height:12.75pt'> </td> <td class=xl2721703>decimals line up ($0.00_�).</td> <td class=xl3321703 align=right x:num>0.75</td> <td class=xl4621703 align=right style='border-left:none' x:num="0.75">.75�</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl2421703 style='height:12.75pt'> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> </tr> <tr height=18 style='height:13.5pt'> <td height=18 class=xl2821703 style='height:13.5pt'>[<=2]"Low"* 0;[>=4]"High"* 0;"Average"* 0</td> <td class=xl2521703>Using "If, ElseIf, Else" in a number format:</td> <td class=xl2921703 align=right x:num>1</td> <td class=xl4721703 style='border-left:none' x:num="1">Low<span style="mso-spacerun: yes">��������������� </span>1</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">������� </span>If the value is <=2, display the word "low"</td> <td class=xl3121703 align=right x:num>2</td> <td class=xl4821703 style='border-left:none' x:num="2">Low<span style="mso-spacerun: yes">��������������� </span>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">��������������� </span>with the value,</td> <td class=xl3121703 align=right x:num>3</td> <td class=xl4821703 style='border-left:none' x:num="3">Average<span style="mso-spacerun: yes">��������� </span>3</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">������� </span>Else If the value is >=4, display the word</td> <td class=xl3121703 align=right x:num>4</td> <td class=xl4821703 style='border-left:none' x:num="4">High<span style="mso-spacerun: yes">�������������� </span>4</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">��������������� </span>"high" with the value,</td> <td class=xl3121703 align=right x:num>5</td> <td class=xl4821703 style='border-left:none' x:num="5">High<span style="mso-spacerun: yes">�������������� </span>5</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703 x:str=" Else display the word "Average" with "><span style="mso-spacerun: yes">������� </span>Else display the word "Average" with </td> <td class=xl3121703> </td> <td class=xl4821703 style='border-left:none'> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3221703 style='height:12.75pt'> </td> <td class=xl2721703><span style="mso-spacerun: yes">��������������� </span>value.</td> <td class=xl3321703> </td> <td class=xl4921703 style='border-left:none'> </td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl2421703 style='height:12.75pt'> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> <td class=xl2421703> </td> </tr> <tr height=18 style='height:13.5pt'> <td height=18 class=xl2821703 style='height:13.5pt'>[Red][<=2]0;[Green][>=4]0;[Black]0</td> <td class=xl2521703>Using "If, ElseIf, Else" in a number format:</td> <td class=xl2921703 align=right x:num>1</td> <td class=xl5021703 align=right style='border-left:none' x:num><font color="#FF0000" style='mso-ignore:color'>1</font></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703 x:str=" If the value is <=2, display the value "><span style="mso-spacerun: yes">������� </span>If the value is <=2, display the value </td> <td class=xl3121703 align=right x:num>2</td> <td class=xl5121703 align=right style='border-left:none' x:num><font color="#FF0000" style='mso-ignore:color'>2</font></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">��������������� </span>with red text,</td> <td class=xl3121703 align=right x:num>3</td> <td class=xl5121703 align=right style='border-left:none' x:num><font color="#000000" style='mso-ignore:color'>3</font></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">������� </span>Else If the value is >=4, display the value</td> <td class=xl3121703 align=right x:num>4</td> <td class=xl5121703 align=right style='border-left:none' x:num><font color="#00FF00" style='mso-ignore:color'>4</font></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3021703 style='height:12.75pt'> </td> <td class=xl2621703><span style="mso-spacerun: yes">��������������� </span>with green text,</td> <td class=xl3121703 align=right x:num>5</td> <td class=xl5121703 align=right style='border-left:none' x:num><font color="#00FF00" style='mso-ignore:color'>5</font></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl3221703 style='height:12.75pt'> </td> <td class=xl2721703><span style="mso-spacerun: yes">������� </span>Else display the value with black text.</td> <td class=xl3321703> </td> <td class=xl5221703 style='border-left:none'> </td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=379 style='width:284pt'></td> <td width=292 style='width:219pt'></td> <td width=99 style='width:74pt'></td> <td width=101 style='width:76pt'></td> </tr> <![endif]> </table> </div> <br> <!-----------------------------> <!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--> <!-----------------------------> </body> </html>
Save
Cancel