Excel 2007 : Multi-variable values, conditions

[tornado25]

Hi guys!

Could you tell me the proper formatting for multiple conditions:

In cell A1 I want to type in values; I want cell B1 to generate a corresponding figure.

For example:

If A1=0 then I want B1 to show 50; if A1=0.1, I want B1 to show 51.6; if A1=0.2, I want B1 to show 53.2, etc.

Thanks in advance! Sorry about the lack of proper terminology!

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[oeldere]

B1 =

Please Login or Register  to view this content.

[zbor]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

[zbor]

Use oeldere solution.

Or something like this ( so you can change values):

=TREND({50,51.6,53.2},{0,0.1,0.2},A1)

[oeldere]

Or use cell references.

a1 = 0.1
b1 = 16
c1 = 50

Please Login or Register  to view this content.

It is the most flexible solution.

[tornado25]

Is there are way to do something similar using the IF function?

[oeldere]

I don't get it.

1) The given answer won't work for you?

2) What are the criteria for an if formula?

[tornado25]

I should probably write it out long-hand to so as not to annoy everyone with my ignorance!

The given solution doesn't work for my particular problem because I don't want to generate an indefinite sequential progression. Given concrete, pre-determined values, I want to generate concrete, pre-determined outcomes. Just to save time, that's all!

If I type into A1 I want B1 to show
0 50
1 33
2 16
3 9

BUT

0.1 51.6
0.2 53.2
0.3 55

Is that clearer? If necessary I can write out all the values for A1 and all the outcomes for B1. Like I said, the outcomes are already decided, I don't need any calculations/computations!

[oeldere]

In that case you could define all values.

Then you can use VLookup to find them.

Probably you get better help if you post an example of your workbook.

I understand your question, but i don't see the avandace of typing 0 instead of 50.

It only put more input errors (i suppose).

Maybe you can use datavalidation if you have a complete list off values.

[tornado25]

How do I use VLookup?

The reason for entering a value into the A1 column is because this is the information I receive; the corresponding figure in B1 needs to be pre-programmed, so I don't have to remember this! Imagine a waiter in a restaurant: he pushes the button (A1) for pepperoni pizza and gets the price (B1). He can then add up the rest of the bill: his customer also had an ice-cream, so he pushes the corresponding button on the cash register (A2) and gets the price (B2); he can then calculate the total cost of the bill (B1+B2).

Like I said, if all this information is pre-programmed into excel, it will save me a lot of time!

Thanks for your help and patience!