Text Entered Into One Cell Equals Number In Different Cell

Jun 24, 2013

So I am having trouble figuring out how to do multiple text to equal multiple numbers. For instance right now I use =IF(E9="JOHN DOE","07", but I would like to have it where IF E9 = John Doe the cell shows 07, but IF the E9 = Sam Doe I want the cell to show 08, and the same IF E9 = Pat Doe the cell shows 09 and so on.

Meaning is there a way to have multiple functions go to a cell dependent on what is entered into E9 for example. I just want to have a number come out in one cell if a certain name is entered in a different cell. I loooked at this post [URL]....which got me started,

View 4 Replies


ADVERTISEMENT

If Cell Equals Text Than Take Network Days And Add By A Number?

Dec 19, 2013

If Cell equals text than take networkdays and subtract by a number

If cell c = RD then take cell m (is a date 12/3) and add that by network days +18. This should tell me how many days to process this file.

View 10 Replies View Related

Greater Than, If Cell Equals Specific Number.

Sep 14, 2009

I have students Kg-5th Gr. I need to identify the ones over-aged when I enter the information. The following is what I'm trying to use but I get Y1 for ever cell. I need it to Identify the student as Y1 for One year overage and Y2 for tow years overage.

View 3 Replies View Related

Running Total In Cell Based Upon New Number Being Entered Into Different Cell

Apr 10, 2014

I am creating a spreadsheet for inventory use. I want to have a running total in (1) cell based upon a new/different number being entered into a different cell.

Column B, Row 1 (This will be a new/different number entered every day - inventory in or out, so positive or negative number)

Column D, Row 1 (This will be a running total based on numbers inserted in previous 2 columns)

Basically what I have is a key inventory. So there is column A with key number, B should be keys IN, C should be keys OUT, or ideally B would be IN and OUT meaning, for inventory IN input a positive number and for inventory OUT input a negative number, and D Should be total.

Column E represents number of keys currently in the inventory. I was going to hide the current inventory column so all you see is IN/OUT and total.

So what I need is to be able to just come in and type in a number in the IN and/or OUT column, without having to add/subtract it with the number already in that column.

Bottom line, I'd like to be able to use IN and/or OUT columns to just type in numbers as they come and not have to worry about what's already in those columns and get correct total number.

Ok here it is. Attached worksheet shows
Column A - Key Numbers...No data value
Column B - Inventory IN
Column C - Inventory OUT
Column D - Total
Column E - Current Inventory(Starting point)

So the formula I used to get what i currently have is (=B2-C2+E2). This way whatever i input in columns C and C. totals out in D. But this way every time I want to add/subtract a number in B and C, i have to add to the number already in the column. I'd like to be able to type in a number in B and C as i go and still have a correct total. I wouldn't mind having just one column for in/out and use positive and negative numbers to differentiate inventory in or out.

Key Inventory - Test.xlsx

View 14 Replies View Related

Fill Cell With Next Consecutive Number If Another Cell Has Data Entered?

Aug 16, 2012

I need to achieve the situation below with a formula. I have tried simply doing, for example, = B3+1 but this throws an error, probably because the value being checked is alphanumeric.

Data
A001

Data
A002

Add next number (A003) when data entered in cell to left

View 2 Replies View Related

IF Cell One And Two Contains Value Then Cell 3 Equals To Text

Feb 18, 2013

For example:
IF I3=A and J3=1 then K3=low
IF I3=A and J3=2 then K3=med

I'll be creating 10 rules like this.

In "I" column the values are A to E while in J column values are 1 to 5.
In K column I want to set if it is low,med or high depending on the value combination of I and J.

View 2 Replies View Related

When A Date Entered On A Specific Cell, Automatically Enter A Text In Other Cell

Jul 10, 2006

I have 6 Headings in excel named...

"A" in cell A1, B in B1, "C" in C1, "D" in D1, "E" in E1 and "F" in F1.

There are two projects.

Project 1 has phase A, D & F and Project 2 has phase A, B, C, D & E.

My Specification follows...

1). Take Prject 1 - Which starts from A...in cell A2 I will keyin "A". When the phase comes to an end I will key in the end date of the phase. As soon as I key in the end date in cell A2 Letter D should automatically appear in the cell D2 and when Phase D comes to an end I will key in the end date in Cell D2 which should automatically keyin F in the cell F2. and is the same case for Project 2.

View 3 Replies View Related

If Cell Equals New PO Turn Entire Rows Text Red And Bold

Mar 2, 2014

Code that will turn the entire rows text bold and red if a cell in that row has the word.

New PO

View 9 Replies View Related

Excel 2003 :: How To Create / Run Cell A Equals Cell B Put Cell C Info In Cell D

Jan 26, 2006

I need to match data in cell A to cell B and then if they equal I need to copy the adjacent cell C to cell X . How do I set up a macro to do this automatically? I have over 5000 cells to compare and match up.. I have Office 2003.

View 7 Replies View Related

Counting If 1 Cell Equals X And Another Equals Y

Aug 8, 2014

I have tried a range of "sumproduct" and "count if" and I am still not having any luck.

What I would like excel to do is to count what surgery/hospital (B)is referring for what product (F)

help.xlsx

View 4 Replies View Related

Limit Number Of Characters Entered In A Cell?

Jul 9, 2014

trying to limit the number of characters entered in a cell.

I clicked on Custom then =LEN(A10)=6 which works when i enter more or less than 6 characters, however it lets you paste in something which has more than 6 charters.

View 8 Replies View Related

Colour Change Cell If Number Entered

Mar 21, 2008

I want to incoroprate into my Workbook a sheet with a list of phone numbers, that sheet can be added to and more numbers entered if necessary and will be called "DATA"

The questions is this. If one of those numbers in the "DATA" sheet is entered in any other sheet in the workbook can the cell that number has been written on (not the one on the data sheet) be made to change colour?

View 9 Replies View Related

Preventing Text Being Entered In A Cell

Oct 2, 2013

How do I prevent or allow text to be entered into a Cell or not. Ie if cell A1 contains the word "Text" I want text to be able to be entered in A2, but if A1 contains "No Text" if want to prevent text being entered A2. Is this possible, if so how?

View 1 Replies View Related

How Excel Understand Numeric Number Entered In Any Cell

Dec 11, 2012

I have Two Sheets in same workbokk.

Sheet1 Sheet2

Sheet1 B2 = "any numeric value (whole digit i.e 10 or 55 like) - user input "

Sheet2 Starting point is cell B3.

What need to happen - As soon as user enter number in Sheet1 B2 = any value say, 20 then,

Sheet2.Select
Range("B3").select

suppose i assign value p as,

dim p
sheets("sheet1").select
p = range("B3).value

now here i want to indetify this number, i.e.- 20 (User input) and then as soon as user enter this value,

step 1 - sheet2 get select.

step 2 - from B3 sheet2, by row wise it select next 20 row as well next 20 columns.

for eg.- from B3, the data should select like following,
B3 to U22.

and this selected area highlight with single border only. That's it.Therefore, my main problem is how excel will understand this numeric number ?

View 9 Replies View Related

If Cell Text Equals Cell Text In A Range Of Cells Display Value From Range Of Cells

Oct 4, 2012

I have the following formula that is supposed to grab a value from C2 and check for that value in a range of cells and if it matches it is supposed to display the corresponding value in another range of cells. What am I missing??

=IF(C2='Google Doc'!$B1122:$B1266,"'Google Doc!K1122:K1266'","Not OK")

View 9 Replies View Related

Make Static Date Appear When Cell Has Text Entered?

Jan 19, 2014

Any way where is a list of cells (b3:b113) has text entered, or specific text entered, it will enter a static cell in the corresponding "d" column.

I know of CTRL + ; but i don't really know how to get it to work as a macro, can't find a forumla that enters the static date, and i don't want to make a macro to copy + paste special the date when it happens.

So all i should have to do is entered text in column b, then it will add a time stamp, when that text was entered, it doesn't have to update.

Like all i need is this, but instead of the "now()" function, it will have another function that doesn't automatically update?

=IF(ISBLANK(E5)=FALSE,NOW(),"")

View 2 Replies View Related

Image Is Hyperlinked To A Cell With Specific Text Entered

Mar 18, 2008

Is there any way I can make it so an image is hyperlinked to a cell with specific text entered. After clicking on the image, the cell where the image is hyperlinked to changes text.

For example:

An image of a strawberry is hyperlinked to a cell which contains the word "strawberry".
After clicking on the strawberry image, the cell which contained the word "strawberry" now contains the word "strawberry1".

If you understand that, I would so love the help.

I also posted this is question here

http://www.excelforum.com/showthread.php?t=637811

View 11 Replies View Related

Auto-link To Another Worksheet When Text Is Entered In Cell

Dec 8, 2009

setting up a worksheet that forces a link to another worksheet when text is entered.

For instance, I will have several columns in the first worksheet (Sheet 1). For each entry, a tally ("X") will be added under the applicable columns. Most of the column headings are pretty straightforward. To keep things uncluttered, I want one of the columns to have an auto-link (?) feature so that when the user adds an X in this one column (we'll call it Column D), the user will then be auto-linked to another worksheet (Sheet 2) in the workbook. Sheet 2 will have room for more information regarding Column D, Sheet 1.

View 14 Replies View Related

Excel 2013 :: Date Placed In Cell When Text Entered In A2

May 8, 2013

Is there a formula which places the date In A5 whenever text is entered in A2 - Excel 2013

View 9 Replies View Related

Change Font Of Text In One Cell Based On Information Entered In Another

Apr 28, 2008

if a macro or private macro is necessary, I would need basic instruction how to use those as well (I mentioned private macro as I understand they automatically run whenever worksheet info is changed, which I would like in this example.)

I'm simply trying to change fonts in cells based on the inputs of other cells. Obviously, using conditional formatting doesn't allow for this.

For my example, assume the word "MrExcel" is in cells D2, F2, H2, J2, L2, N2, P2 and R2. If I type different font names (Times New Roman, Arial, Bookman, etc.) in the cells to the immediate right of each word "MrExcel," -- cells E2, G2, I2, K2, M2, O2, Q2 and S2 -- I would like the "MrExcel" word in each corresponding cell changed to the corresponding font to the right. I would like the ability to do this for up to 15 different fonts. There will be many rows to this worksheet I need to use this process for.

Is this possible? I'm in a bit of a jam and have exhausted my knowledge of formulas in that they won't work in this case ... I'm assuming I need to delve into the unknown land (to me) of macros, private macros, or VBA.

View 9 Replies View Related

How To Get Automatic Popup Message When Cell Text Is Entered To Column Range

Jul 10, 2013

I have an excel file with many worksheets. I want to get a pop up message providing definitions of different subjects when they are entered from a drop down list in a specific range within a column to improve the users understanding of the subjects.

Worksheet 1
Range (where I want the pop up message to be valid): J85:J385
Subjects from drop down list in specified range: "x,y,z"
Pop up message: "Definitions of x,y,z"

Do I have to make a new module, or write the macro in the selected worksheet? What should be the settings of the macro (general, worksheet, declarations etc.)

View 7 Replies View Related

Clear Cell Contents If Another Cell Equals String

Sep 23, 2013

I have a 700 line spreadsheet and would like to delete the cell next to another cell if it contains a certain string. I.e if A1 to A3 equals "Test" then i would like to delete the contents of B1 to B3, But if A2 equals "Completed" then only B1 and B3 should be cleared.

View 4 Replies View Related

Macro To Loop Until Cell Value Equals Another Cell Value?

Jan 8, 2013

I have a Random Number macro that will generate a random number (from 1 to 50) and place it into cell C4 of the worksheet. From there, various calculations are performed in the spreadsheet, ending with a value in cell AB5 and cell AB6. Depending on this random number, occasionally the value of cell "AB5" and cell "AB6" do not match. I want the macro to continue looping (generating another random number until a match is made between AB5 and AB6). I've tried various things but nothing is working to make it loop.

Below is the code for the random number macro.

VB:
Sub RandomNo()
Randomize
MyNumber = Int((50 - 1 + 1) * Rnd + 1)
Range("c4").Value = MyNumber
End Sub

View 4 Replies View Related

How To Delete Row If Cell Value Equals Cell Value In Another Sheet

Apr 27, 2013

I have some data in sheet 1 column A. However, the amount of data varies everytime. In addition, blanks cells may be present in column A as well.

I have some data in sheet 2 column A. The amount of data also varies everytime. In addition, blank cells maybe present as well.

what I need here is to match the values in column A sheet 1 to column A sheet 2, and if it matches to delete the entire row in sheet 1.

However, i want to keep all blank cells in column A sheet 1.

Sheet 2 blank cells to be removed if any.

how do I do that in VBA? A lot of forums talk about a specific value but none on non specific values.

View 6 Replies View Related

Change A Cell To Being Locked When Cell Equals Certain Value

Oct 14, 2007

The spreadsheet is password protected. The only cells that students can enter values into are the answer cells.

I am trying to figure out how to have a cell switch to being locked if the correct answer is inputted. ( I have a column that I hide that has the correct answers in it. Then I use a countif function to determine if the answer cell equals the inputted answer.)

View 9 Replies View Related

UserForm Text Box Code (whatever Text Has Been Entered Into The Userform To Be Put Into A Cell )

Feb 1, 2010

I've created a userform with a text box and a command button (Enter)

On clicking the command button I'd like whatever text has been entered into the userform to be put into a cell (Say A1).

View 2 Replies View Related

Calculate The Number Of Days From A Date Entered Into Cell A1 To Today's Date

May 19, 2009

I need a formula that will calculate the number of days from a date entered into cell A1 to today's date. Whether it's before or after todays date. Example:

5/10/2009 to today is -9

5/22/2009 to today is 3

View 2 Replies View Related

Find Last Number In Row / Add 1 To Current Cell (if Another Cell In That Column Has Text)

May 23, 2014

file storage

1. Look at the "Days so far" section

2. Ignore cell C1

3. All the other cells in that row are shaded blue. Look at these.

4. Look at the "Volunteer" row - all the cells in that row are shaded blue. Look at these.

5. Wherever a name - any name - appears in the "Volunteer" row, 1 is added to the previous number in the "Days so far" section and the result is displayed in cell from the "Days so far" row above that Volunteer's name.

6. For example, we begin in C1 with a count of 12 days so far - this was manually entered

7. In cell H5, we see Henry has volunteered 1 day. The total no. of days so far should now be 12+1. Therefore, the number in H1 should be 13.

8. In cell G47, we see Joseph has volunteered 1 day. The total number of days volunteered BEFORE Joseph volunteered is 15 (see cell D43). But now, with Joseph volunteering 1 day, the total no. of days so far should now be 15+1. Therefore, the number in G43 should be 16.

9. what formula l must put in the "Days so far" row (excluding cell C1, which is manually input) to give me the "should be" results predicted in that row? I'm guessing it will be a formula which looks at each row fragment of the "Days so far" row, row by row, right up to the previous cell in that row, all within one formula.

P.S. I just want to leave the "Days so far" row blank, for any columns where there are no volunteers in the "Volunteer" row, so please don't give a formula which inserts zero for days with no volunteer, and then sums the cumulative total.

View 5 Replies View Related

Text In Cell Then Formula To Put Particular Number In Adjacent Cell

Feb 16, 2014

I have text in column A of either "xxx" or "yyy"

I'm looking for a formula so that If

A1: "xxx" then B1: $100
Or if
A1: "yyy" then B1: $150

So when I write "xxx" or "yyy" in a cell of Col A

then $100 or $150 shows up in adjacent cell in Col B automatically.

I will need to sum the numbers later so Col B will need to be in number/accounting format.

View 3 Replies View Related

Equals Cell If Another Cell Is Empty

May 9, 2014

In cell D4 I have =Q8.

I only want it to =Q8 if cell H1 conatins a value and is not blank. If its blank I dont want anything in D4

What can I add here.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved