Input Cell
 

I need a formula that will input a number. If a1 1 then input a1, if a1 < 1
then input b1 and if b1< 0 then input c1.

Input Cell
 

Hmm... what if a1 = 1?

Try something like:

=IF(A1=1,A1,IF(B1<0,C1,B1))

In article ,
brandon wrote:

I need a formula that will input a number. If a1 1 then input a1, if a1 < 1
then input b1 and if b1< 0 then input c1.

Input Cell
 

try
=if(a11,a1,if(a10,b1,c1))

--
Don Guillett
SalesAid Software

"brandon" wrote in message
...
I need a formula that will input a number. If a1 1 then input a1, if a1 <
1
then input b1 and if b1< 0 then input c1.