Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Formula for multiple cells

I need to be able to input a number in cells a1 through a10.

I need those numbers to reflect a formula, IN the cell i typed the number in.

Example:

cell a4, i type in 4.
the formula multiplies 4 * .01 (turning 4 into a percent number) THEN by 2000.

So, when i input the number 4, i get displayed 80.

Any insight is much appreciated.
Reply
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i use multiple cells to create a formula ? Rob Welsh (Austin) Excel Discussion (Misc queries) 5 February 24th 10 05:28 PM
Using one cells formula in multiple other cells Eric Excel Discussion (Misc queries) 1 June 18th 08 12:15 AM
changing a formula in multiple cells casdaq Excel Worksheet Functions 2 April 30th 07 11:54 PM
Look up formula, multiple cells pgarcia Excel Discussion (Misc queries) 8 January 30th 07 10:28 PM
apply a formula to multiple cells FixitFrog Excel Discussion (Misc queries) 3 June 23rd 05 11:54 AM


All times are GMT +1. The time now is 11:53 PM.

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

About Us

"It's about Microsoft Excel"