Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default formula

Using Excel 2003.

I want all the data in a row to take a specific formula, say = X * 3. But
the value of X varies for each of the cell. How do I do so without having to
type in the same formula for each cell?

Furthermore I want the value of X for each cell to be seen. Thus I don't
want to enter all X in row 1 , and in row 2 enter =A1*3. Then copy & paste
the formula onto the entire row. Because by doing this, people can't tell
what is A1, B1,....

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"