Thread: Input Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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.