Thread: I want to set up a cell where 1=3 so when I insert 2 it will = 6
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default I want to set up a cell where 1=3 so when I insert 2 it will = 6
In B1 enter = A1*3

Whatever you enter in A1 will be multiplied by 3


Gord Dibben MS Excel MVP

On Sat, 9 Sep 2006 12:09:01 -0700, Ciscokid
wrote:

I am setting up a Excel worksheet for accountibility and what to simplify it
by having one number in a column equal another number in the next cell. I am
using Excel 2003

Reply With QuoteReply With Quote