#Value resulting from formula that traps it??

[synergy46]

Below is column C. It is being evaluated by the formula:
=IF((ISERROR($C4)),"",IF($C4="Deposit",$C4,IF(OR($C4="Check",$C4="Debit Card"),$C4*-1,"")))

Yet, the result shows #VALUE; which I thought would have been taken care of by the ISERROR function? What am I missing????

****** name="Title" content="Actual vs Budget"> ****** name="Keywords" content=""> ****** http-equiv="Content-Type" content="text/html; charset=utf-8"> ****** name="ProgId" content="Excel.Sheet"> ****** name="Generator" content="Microsoft Excel 2008"> <link id="Main-File" rel="Main-File" href="file://localhost/Users/Ron/Library/Caches/TemporaryItems/msoclip/0/clip.htm"> <title>Actual vs Budget</title> <style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .font5 {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} .font6 {color:black; font-size:9.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} .font7 {color:black; font-size:9.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} td {padding:0px; mso-ignoreadding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {mso-number-format:"_\(\0022$\0022* \#\,\#\#0\.00_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)"; border-top:.5pt solid windowtext; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl25 {font-size:9.0pt; font-style:italic; mso-number-format:"\@"; text-align:center; border-top:none; border-right:none; border-bottom:1.0pt solid #000090; border-left:none; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl26 {text-align:center; background:#FFFF99; mso-pattern:auto none;} .xl27 {mso-number-format:"_\(\0022$\0022* \#\,\#\#0\.00_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)"; text-align:center; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl28 {mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)"; text-align:center; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl29 {color:#DD0806; text-align:center; mso-protection:unlocked visible;} ruby {ruby-align:left;} rt {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-char-type:none; display:none;} --> </style> <table style="border-collapse: collapse;" width="71" border="0" cellpadding="0" cellspacing="0"> <!--StartFragment--> <col style="" width="71"> <tbody><tr style="" height="21"> <td class="xl29" width="71" height="21">C</td> </tr> <tr height="14"> <td class="xl25" height="14">Type</td> </tr> <tr height="13"> <td class="xl27" height="13"> Check </td> </tr> <tr height="13"> <td class="xl28" height="13"> Deposit </td> </tr> <tr height="13"> <td class="xl28" height="13"> Check </td> </tr> <tr height="13"> <td class="xl28" height="13"> Deposit </td> </tr> <tr height="13"> <td class="xl28" height="13"> Debit Card </td> </tr> <tr height="13"> <td class="xl26" height="13">Check</td> </tr> <tr height="13"> <td class="xl26" height="13">Deposit</td> </tr> <tr style="" height="13"> <td class="xl26" height="13">Check</td> </tr> <tr height="14"> <td class="xl24" height="14"> </td> </tr> <!--EndFragment--> </tbody></table>

 

[tusharm]

If C4 is 'Check' or 'Debit Card' (i.e., a text value) how do you expect Excel to multiply it by -1?

Below is column C. It is being evaluated by the formula:
=IF((ISERROR($C4)),"",IF($C4="Deposit",$C4,IF(OR($C4="Check",$C4="Debit Card"),$C4*-1,"")))

Yet, the result shows #VALUE; which I thought would have been taken care of by the ISERROR function? What am I missing????

****** name="Title" content="Actual vs Budget"> ****** name="Keywords" content=""> ****** http-equiv="Content-Type" content="text/html; charset=utf-8"> ****** name="ProgId" content="Excel.Sheet"> ****** name="Generator" content="Microsoft Excel 2008"> <link id="Main-File" rel="Main-File" href="file://localhost/Users/Ron/Library/Caches/TemporaryItems/msoclip/0/clip.htm"> <title>Actual vs Budget</title> <style> <!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} .font5 {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} .font6 {color:black; font-size:9.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} .font7 {color:black; font-size:9.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0;} td {padding:0px; mso-ignoreadding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {mso-number-format:"_\(\0022$\0022* \#\,\#\#0\.00_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)"; border-top:.5pt solid windowtext; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl25 {font-size:9.0pt; font-style:italic; mso-number-format:"\@"; text-align:center; border-top:none; border-right:none; border-bottom:1.0pt solid #000090; border-left:none; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl26 {text-align:center; background:#FFFF99; mso-pattern:auto none;} .xl27 {mso-number-format:"_\(\0022$\0022* \#\,\#\#0\.00_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)"; text-align:center; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl28 {mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(* \0022-\0022??_\)\;_\(\@_\)"; text-align:center; background:#FFFF99; mso-pattern:auto none; mso-protection:unlocked visible;} .xl29 {color:#DD0806; text-align:center; mso-protection:unlocked visible;} ruby {ruby-align:left;} rt {color:windowtext; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Verdana; mso-generic-font-family:auto; mso-font-charset:0; mso-char-type:none; display:none;} --> </style> <table style="border-collapse: collapse;" width="71" border="0" cellpadding="0" cellspacing="0"> <!--StartFragment--> <col style="" width="71"> <tbody><tr style="" height="21"> <td class="xl29" width="71" height="21">C</td> </tr> <tr height="14"> <td class="xl25" height="14">Type</td> </tr> <tr height="13"> <td class="xl27" height="13"> Check </td> </tr> <tr height="13"> <td class="xl28" height="13"> Deposit </td> </tr> <tr height="13"> <td class="xl28" height="13"> Check </td> </tr> <tr height="13"> <td class="xl28" height="13"> Deposit </td> </tr> <tr height="13"> <td class="xl28" height="13"> Debit Card </td> </tr> <tr height="13"> <td class="xl26" height="13">Check</td> </tr> <tr height="13"> <td class="xl26" height="13">Deposit</td> </tr> <tr style="" height="13"> <td class="xl26" height="13">Check</td> </tr> <tr height="14"> <td class="xl24" height="14"> </td> </tr> <!--EndFragment--> </tbody></table>

 

[synergy46]

Right, that C4 should have been E4 (a numeric value). Thanks for pointing that out. (I had been staring at that formula for 30 minutes and couldn't see it).