Hi,
Running an XP SP-3 machine Office '03 Pro and Window eyes 7.2. Having reinforced what I know about Excel formulas and arguments in the Excel documentations, I find myself unable to resolve the following riddle. Why does the following Excel formula work fine if the value in H5 is entered directly and does not work when the value in h5 is the result of a formula =if(h5 = 0,"Account Balanced","Out of Balance") For example, if I just enter a 0 in H5 then g5 (where the above formula is) will display the text "Account balanced". If I enter a number larger or smaller than 0 in h5, g5 will display the text "Out of Balance". However, if h5 is the result of a formula, for example h3-h4, then G5 will always display "Out of Balance", regardless of the value in h5. Thanks. Sincerely, Donald E. Bowen, Jr. <http://mysite.verizon.net/reszmkrl/musicforsight/author.html> Music for Sight <http://musicforsight.org/> If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
