# Thread: How to Create an Excel Formula

1. Registered User
Join Date
Feb 2012
Posts
4

## Unanswered: How to Create an Excel Formula

I need help creating a formula to say if the amount in column A is "x " then column B must equal "y". Can anyone help me?

2. Registered User
Join Date
Sep 2008
Location
London, UK
Posts
511
Would you be a little more specific? Should the two cells always add up to give the same total or something?

3. Registered User
Join Date
Feb 2012
Posts
4
Sorry about not being to clear.

I want column B to always be a certain amount based on column A.

For example if A is always 105.92 then B should always be 66.11 the in the next row if column A is 91.59 then the corresponding row in B should be 22.11

I have probably sixteen different figures for column A and each one means that column B would be sixteen different responses.

4. Registered User
Join Date
Oct 2003
Location
London
Posts
341
Hi. You probably still need to be a little clearer as to what you want.

What is the relationship between A and B?

If A can ONLY be chosen out of a selection of 16 possible options, and each of those options can have only ONE corresponding value in B, then a lookup table would be appropriate. In that instance I would expect that somewhere within your spreadsheet you have a table outlining those 16 options and their corresponding values.

Assuming this is correct, and that your Table is in C1 to D17, and again assuming the value that A2 is the first value you want to check;

B2 will contain the formula =VLOOKUP(A2,\$C\$1:\$D\$17,2,FALSE)
B3 will contain the formula =VLOOKUP(A3,\$C\$1:\$D\$17,2,FALSE)
B4 will contain the formula =VLOOKUP(A4,\$C\$1:\$D\$17,2,FALSE)

and so on...

5. Registered User
Join Date
Feb 2012
Posts
4
Yes I think that will work just fine. "A" would be called "Total Paid" and "B" would be "Rent Portion Paid of Total Paid" .

The precalculated list I have been given tells me if any of one the sixteen different totals paid is this then I know the Rent portion of that total will be that.

But I think your way will work. I will try it out.

Thank you. This has been the first time I have ever asked for help on a forum and with such great help I am sure I will be back for more.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•