- #Two percentages and a dollar combo in excel full#
- #Two percentages and a dollar combo in excel code#
- #Two percentages and a dollar combo in excel plus#
STEP 2: This time click on the tab at the bottom for S/S #3.
#Two percentages and a dollar combo in excel plus#
Here you are defining where you want Excel to search for the variable you entered plus the value assigned to that variable. This will return your selection to the F/A screen. STEP 4: Click on the RH button on the small popup. STEP 3: Now click on the variable in Row2/Col2 (notice that that cell is now shown in the small popup). STEP 2: Now click on the tab at the bottom for S/S #1.
STEP 1: Click on the RH button with the red arrow in it. This brings up the FUNCTION ARGUMENTS (F/A) screen. Type in VLOOKUP if it not present in the list shown and click GO or just dbl-click on it, if shown in list. Click on the “fx” button and the FUNCTION WIZARD will appear. The easiest way to create your formula is to use the “fx” FUNCTION button at the top of your s/s, just below the command ribbon. Go to S/S #2 : Now we want to enter our formula in Row2/Col2. (This is not a requirement, but it does let you see if your formulas are set-up correctly. Go to S/S #1 : Enter some test values (Row 2 / Cols 2-32) for your first patient….HW, AA, etc. NOTE: This table could have been created on either of the other s/s, but to keep things clean, I suggest using a separate spreadsheet for your variables These variables do not need to be input in any particular order.
You can have as many variables as you want, but as I mentioned previously, each variable must have a single value, otherwise Excel will always select the first value it comes to that is associated with that variable. Spreadsheet 3 : This is where you want to create a table of values for all your variables…AA, HW, SL, etc. This would simply be the values in Row 1 (NAME plus days of the month) plus the names of your patients. Spreadsheet 2: Copy Spreadsheet 1 (before you fill-in any values for the patients) and paste in Spreadsheet 2 Cols 2-32 would be the value assigned to that patient for that particular day….AA, HW, etc.Ĭontinue repeating for as many patients that you wish to track Row2 would contain the patient’s name in Col 1. Spreadsheet 1 : Row1 would contain the title NAME in Col 1 and the numerical day of the month in Cols 2-32. As you said, it would be so much easier if you could post pictures, but here goes……… It’s created to do exactly what you want……find a value for a cell based upon the content of another cell. The best way to do this is probably using VLOOKUP. I then want to be able to total the rows, total columns and do other calculations based on formulas I create. So what I want is auto population of spreadsheet 2 based on known values created for the alpha characters in the corresponding boxes on spreadsheet one. If it is a weekend a ‘w’ is placed in the box, etc.Ĭolumn 33 total 2:24 there are other calculations but notĬolumn 2 if x is in corresponding box on spreadsheet 1, then numeral 1 will be in the box on spreadsheet 2Ĭolumn 3 if HD is in the corresponding box on spreadsheet 1, than 0.5 will be in the corresponding box on spreadsheet 2 and so on.
#Two percentages and a dollar combo in excel full#
If they are there for a full day an ‘x’ is placed in the box.
It would be so much easier with a picture.įor each name the day is completed with an activity. I am probably making this way more complicated then it needs to be. This may be a duplicate because I don’t think I asked for a response the first time around. If I get by without needing the extra columns (like colC and colD above),then that would be great, but I need to have the negative values appear as say X-3.452 and Y-1.500 instead of having the negative sign go before the X and Y letters. I ended up copying the values in colA and colB to create colC and colD, and then for colD set it to =”Y”&A1 or =CONCATENATE(“Y”,I3), and that fixes the issue so the – sign will be after the Y (which is what I want), but it just lists the number to two digits (drops off the zeroes) instead of the three digits that I’d like. The issue is, that I need to have the negative value appear as Y-1.500 instead of -Y1.500. If I select cell A1 and choose Format Cell/Number/Custom and use “X”0.000 and then “Y”0.000 for cell B1, then they will appear as X3.150 and -Y1.500.
#Two percentages and a dollar combo in excel code#
I want to add an X in front of the column A values and a Y to the column B values as I want to then copy and paste the values into another file (writing simple G code for a CNC mill). Hello!! I’m working on a file where I will have positive and negative numbers in columns A and B like is shown below, with those columns being calculated from various cells.
0 kommentar(er)
