close
I need a formula that will input a number. If a1 gt; 1 then input a1, if a1 lt; 1
then input b1 and if b1lt; 0 then input c1.
Hmm... what if a1 = 1?
Try something like:
=IF(A1gt;=1,A1,IF(B1lt;0,C1,B1))
In article gt;,
brandon gt; wrote:
gt; I need a formula that will input a number. If a1 gt; 1 then input a1, if a1 lt; 1
gt; then input b1 and if b1lt; 0 then input c1.
try
=if(a1gt;1,a1,if(a1gt;0,b1,c1))
--
Don Guillett
SalesAid Software
quot;brandonquot; gt; wrote in message
...
gt;I need a formula that will input a number. If a1 gt; 1 then input a1, if a1 lt;
gt;1
gt; then input b1 and if b1lt; 0 then input c1.
全站熱搜
留言列表
