LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Inputs.

please help with a function that I am unfamiliar with.

say a1=1 and b1= "=a1*2"

I then want a3, a4 and a5 to be 2, 3, 4 respectively, and
I want b3, b4, and b5 to be the b1 function above where
instead of a1 it would be a3, a4, a5 etc.... without
having to repoduce the equation in b3, b4, b5 and still
get the right answer.

i.e. In B3 I want to be able to write "if my input is A3,
into the equation written in b1, then my answer would
be ..."

Basically I have designed a formula that involves various
tabs, and I cant compress it into one cell to crunch 100
different inputs, and I want to be able to compare all
the different answers at the same time.

Thanks for the help.
 
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
Quarterly inputs Loadmaster Excel Worksheet Functions 2 August 28th 09 03:22 PM
custom inputs Tom Excel Discussion (Misc queries) 1 September 2nd 08 10:39 PM
A question of two inputs Finance Guru Excel Worksheet Functions 0 March 27th 08 01:58 PM
Help with Date Inputs Mark[_38_] Excel Programming 0 March 4th 04 01:58 PM
userform inputs Jouni Excel Programming 0 September 19th 03 10:51 PM


All times are GMT +1. The time now is 01:53 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"