close
in some other cell,=if(a1=quot;quot;,quot;quot;,a1/8,if(b1=quot;quot;,quot;quot;,b1*8))
--
paul
remove nospam for email addy!
quot;tjbquot; wrote:
gt; When the user enters a number in cell A1, I want cell B1 to divide that
gt; number by 8. If A1 is blank then B1 should be blank.
gt;
gt; Alternately, when the user enters a number in cell B1, I want cell A1 to
gt; MULTIPLY that number by 8. If B1 is blank then A1 should be blank.
gt;
gt; I'm pretty sure this has to be a workbook function but I'm not sure how to
gt; proceed. Any ideas all?
全站熱搜
留言列表
