Thread: Options in Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon M.[_2_] Jon M.[_2_] is offline
external usenet poster
 
Posts: 5
Default Options in Cell

Is there a way to create;

A1=If(b10,b1, (otherwise 0 or user input)

so if b1=1 then a1=1, if b1=0 then a1 would = 0 or else a
value inputed by the user.