# Excel formula, thanks rmeyer for your help but a need a bit more if possible. here is an example hope it makes sense, cell b2 =if(a1=1,"25") now what i want to do is say i put a 1 in cell a1 i know cell b2 will show 25, but if i put a 2 into cell a1 is it possible to add to the formula in cell b2 so that the answer in cell b2 would be say 10, so how can i write the formula so the different figure i put into cell a1 will give me a different answer in cell b2. Cheers for any help in advance.

Posted by on

• Richard Meyer May 11, 2010

I think what you are asking is for the formula to change based on what you put into the cell. Yes but to really help you I will need exactly what you are looking for. I am going to work on the one you gave me a1=1 thus b1=25 then if a1=2 thus b1=10. I am not sure I could write a formula for that to repeat in that relationship but I might be able to get it to do just that.

• Richard Meyer May 11, 2010

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Expert

The basic idea of an if statement is just that if this then that. Thus a formula could look as simple as =IF(A2=1,25,IF(A2=2,10))

Posted on Jan 10, 2009

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### I calculated percentage on excel using a formula but still it shows #value?. what do i have do to fix this? please help.

Right Click on cell with mouse and select format cells
then select number . If formula was for example percentage of cell a2 calculated from b2 calculated in c2 then in c2 you put =a2/b2
Then you can use percentage in the number format
or you can go =(a2/b2)*100
Also make the cell width more if a problem.

Apr 08, 2017 | Excel Computers & Internet

### In Excel adding positive and negative numbers

Yes,

1. Select the column. (click on top of the column it will select)
2. Right Click and select Format Cells.
3. Select Currency in Category then press OK
Now just type your Numbers i.e. 571 for \$571 and -650 for -\$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Computers & Internet

### Need to take create a formula that takes a cell

Hi sug04
These are couple of solutions
First. Solution
• Take away 20% means the answer is 80%
• 20% means 0.2 of a number, 80% means 0.8 of a number
• So If you have 200 in Cell B1
• And you want 20% less in B2
• Goto B1 type 200
• Goto B2 type like this =B1*.8 and press ENTER
• Now Cell B2 displays 160 which is the correct answer
Second Solution
• Goto B1 type 200
• Goto B2 type like this =B1-(B1*.2) and press ENTER
• Now Cell B2 displays 160 which is the correct answer

Good luck, have a nice day
Please give a Rating to this solution
luciana44

Sep 17, 2009 | Microsoft Excel for PC

### Writing a formula for a sumif problem

Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

### Formula not working correctly

You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

Apr 16, 2009 | Oracle Database Enterprise Named User Plus

### Add 20% uplift price to a pricelist in an excel spreedsheet

lets say you have the column B with the prices. Got to column C right beside the first price cell (I'll take B2 as first cell for example) which is C2 and type
=1.2*B2

Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.

Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)

Feb 25, 2009 | Computers & Internet

### Excel formula

You can do that using the formula CONCATENATE, solving your report.
in C2 you could write: =CONCATENATE(A2,B2)
in C3 you could write: =CONCATENATE(A3,B3)
in C4 you could write: =CONCATENATE(A4,B4)
in C5 you could write: =CONCATENATE(A5,B5)

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

### Excel formula help

formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

### Copying data from one sheet to another if two fileds match

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):
A1: Part B1: Code C1: Price D1: Find Part E1: Find Code
A2: x B2: 11 C2: 5.00 D2: y E2: 12
A3: x B3: 12 C3: 6.00 D3: y E3: 11
A4: y B4: 11 C4: 7.00 D4: x E4: 12
A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:
=INDEX(\$C\$2:\$C\$5,MATCH(D2,IF(\$B\$2:\$B\$5=E2,\$A\$2:\$A\$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

### Help with simple excel calculations

Hello.

For cell B1 you can use this (without the quotes) "=A1"

Then for cell A2 and down you don't need a formula, but for B2 you can use this formula. "=(B1+A2)" Then click on that cell and drag the mouse down for as many cells as you want this formula to include and press Control and F keys to fill the formula down the column.

For your second formula, you would type 100 into D1 and in D2 you would use the formula "=D1-E1" (again, no quotes).

Feel free to let me know if you need any more clarification or if I missed something!

Jun 10, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

130 people viewed this question

Level 3 Expert

Level 3 Expert