View Single Post
  #1   Report Post  
JCLim
 
Posts: n/a
Default product calculation in excel

can anyone advice me on the below scenerio?
eg. a * b = c

In cell A1, I input value a. I need to get c in cell A5. But b can only be
input in cell A5 too. Meaning when I key in b in cell A5, automatic c will
appears in cell A5.

Is there a way to do in excel? Please advice. Thanks.