# If / Then Formula: Makes A Character That Has A Score Of 9 For One Of His Attributes?

Oct 29, 2008

I'm helping out a community that puts out a role playing game by making a character sheet for their gaming system. It's normally a pen-and-paper type affair, but a few people have reached out to me and asked me to make it. Now, one thing that I really thought would be nifty would be to make it persistent. I know of the Excel basics, creating basic formulas and the such, but this is where I hit a brick wall.

For the character sheet, they normally have basic attributes on a 1-20 scale. These attributes are accomanied by a bonus. The only thing is those, while these bonuses go across a linear path (For attribute 1, it's -30, for 2 its -20, for 3 its -10, for 4 its -5 for 5 its 0....), I cant seem to figure out how to create some kind of If/Then formula for it....

Heres my example:

Brad makes a character that has a score of 9 for one of his attributes. The bonus given to someone with a 9 is a +10. What I'm looking to do is create a table that sees that 'If (c9)=9, Then (d9)=+10'...

And my second related issue...

Is there any possible way to do the above mentioned formula in relation to a drop down selection bar? It's the same thing here; To break it down simply, It would be excellent if there was a way for it to say If (a10)=Warrior, then (c10)= +10.

## Formula To Work Out Score Based On Score System

Aug 10, 2009

I want to see if i can make a formula that works out how a player got a score based on a scoring system. See the attached file for more details. I want this to show that the player scored or didn't score, played a full match or was a substitute, was booked or wasn't booked and was sent off or wasn't sent off.

## Formula That Will Work Out Score Of Individuals

May 31, 2012

I currently have a sheet of data with names and scores (1-10) on e.g.

NameScoreJohn10Smith5Steve4John9

and what i am wanting is a formula that will read these columns and tell me the amount of 1's, 2's, 3's, 4's, 5's, 6's, 7's, 8's, 9's and 10's the corosponding name has gotten.

for example:

JohnSmithSteve123415167891101

I have been playing around with COUNTIF formulas but cannot seem to work this out.

## Converting Score Sheet To LOOKUP Formula?

Apr 13, 2009

I have a paper-based scoring sheet that we use to determine a rating category. I cannot figure out how to convert this scoring sheet into a lookup region and use some type of LOOKUP formula to determine the rating. I have looked at the various Grading examples on the Internet that show you how to look up a grade, based on a score, but they only look up a grade, based on a single input (the score).

Here I have two values going in--the person's age and their score, and I need to look up the rating, which is the column heading.

Can anyone point me in the right direction?

I've attached a sample spreadsheet which shows the original scoring sheet.

## Formula For 2 Low Net & 1 Low Gross Score In A 5 Man Golf Team

May 25, 2008

I am using Excel 2002 in Xp and also want to use the spreadsheet on my Pocket PC using Pocket Excel.

I have a column of 10 numbers with rows 1,3,5,7 & 9 representing the individual gross scores of the 5 team members. Rows 2,4,6,8 & 10 have either a 0 or -1 (calculated) in them representing the strokes (or discount) the player receives for that hole. So the net scores for each player will be row 1 + row 2 and so on.

I need a formula that will calculate the total of the 2 lowest net scores and 1 low gross score with the score for each player only being used once which will then represent the team score for that hole.

A sample column would have 4,0,3,0,4,0,3,0,5,-1 in it.

## Formula That Reads Grade And Then Ranks These By 1st-5th Place According To Score

Feb 10, 2014

I'm creating a Speech and Debate calculater that presents winners names by place according to their score. If you look at Tab HSSE Results it will read the inputed information from HS Speech English. I want the names of the students to appear in the correct ranking order in the respected grade rankings chart. I currently have a countif formula which reads the grade, but I think I need to link that with an index formula which I'm having problems with.

## Formula / Conditional Format To Award Score From 0 To 4 Depending On Cell Value

Jul 24, 2014

I want to create a system based on the value of a cell appearing as a grade in the adjacent cell. The cell could contain any value from -10 to +10.

the criteria would be

value greater than +2 = 3
value between 0 and +2 = 2
value between -2 and zero =1
value below -2 =0

I can get a formula to work for a single instance but not multiple conditions.

## Array Formula To Lookup Two Values And Produce A Total Score

Nov 19, 2009

I have a table of data where each row is a person, and each column is a group that person might belong to. In the intersecting cell of a person row and group column is text showing what position they hold in that group (eg Director, Head, member etc). In many cases the cell is empty because the person is not involved with the group.

There are then two lookup tables which have scores; one for the group name and one for the position type. The group name is always the column header. I have used these lookup tables as I would like the scores for each group or position to be easily adjustable.

Probably best that I just attach an example. I tried to solve this using SUMPRODUCT. VLOOKUP on the two lookup tables would have been good but it seems it doesn't work with arrays the way I expected. My attempt (which doesn't work obviously!) is given.

## Worksheet/formula That Automatically Look For The Equivalent Score In A Given Transmutation Table

Mar 25, 2003

how can i make a worksheet/formula that automatically look for the equivalent score in a given transmutation table.

example: i have an exam of 10 items, what will be my formula to so that it will automatically look for the equivalent score under the transmutation table of 10 items

## Replace Character Used In Formula Where Formula References Cell

Feb 23, 2008

I am using vlookup to get a cell value from another sheet, but if the cell has "&" or "/" I need to substitue "&" and "/" with "and" so that the cell can be added later to a url.

i am using =VLOOKUP(a1,Sheet2!A1:W17968,6) to get the value of a1 in sheet 2 and return the value of column 6

this will return "Audio Cables & Leads" but i need it to say Audio Cables and Leads

I need the formula to also check and replace "/" with "and" as well so cables/wire will be Cables and wire

## Changing Button Attributes In VBA

Oct 30, 2008

I am using VBA to change the attributes of Command Buttons on a number of pages and due to the numbers involved wanted to automate the process.

Unfortunately whilst I can select the buttons, changing the attributes I cannot get to work, e.g. For Command buttons CB1 and CB2

## Need Target To Have Same Attributes As Source

Mar 29, 2013

I am trying to have the exact same type of text (font, color, boldness, italicizing, underlining, etc) in my target as I have in my source on a character by character basis. The procedure below works for color only. Is there a way I can modify this procedure to include all cell attributes for each character in my target? I looked at the Font properties and couldn't find what I needed. Maybe I need to do it in a totally different way?

For Each cell In source
With cell
target.Characters(i, Len(.Value2)).Font.Color = .Font.Color
i = i + Len(.Value2) + Len(delim)
End With

## Pivot List Of Attributes

Jun 20, 2006

I have a list of user attributes which I would like to merge into a template. I have attached a copy of the template and a copy of the user attributes sheet. The attributes have been downloaded directly from a database so there is one attribute per line. For eg 1 user may have 5 cost centres assigned to him. I would like the 5 costs centres to show up under the template. The problem I have is the template is set up for one line per user with multiple fields for cost centres, therefore I need some way of taking the following output.

User Attribute Value
111 CC CA1023
111 CC CA1204
111 CC CA3333

And merging into the following template

User CC1 CC2 CC3
111 CA1023 CA1204 CA3333

Each user has multiple attributes (Cost centre, internal order, etc) I am only worried about the cost centre field for the time being. Also each user may have 0-10 cost centres assigned

## Code Makes Negative Percentages Red?

Aug 17, 2014

Following link explains how can format negative percentages.

[URL]....

Following code makes negative percentages red, positive percentages green.

[Code].....

I want to make; negative percentages red, positive percentages green, zero percentages blue, ---------->This is my question.

Attached File : Color Format.xlsm

## Save Workbook When User Makes Changes

Sep 24, 2009

I wrote a code that is suppose to save the workbook every time a change is made but so far I have been unsuccessful at getting it to work. The workbook contians 7 worksheets.

This is the code I wrote to try and accomplish this task ....

## Click On Cell Makes Calendar Pop Up

Dec 27, 2007

I have read through numerous posts, but cannot get one thing to work. I am using Excel 2003, and am trying to get a calendar to pop up, to select a date, and then return that date to Cell B2.

I was successful at making the calendar pop up by the following methods:
1. Added a button to the toolbar, and assigned the Calendar Macro to it.

Private Sub Workbook_Open()
Application.OnKey "+^{C}", "Module1.Macro2"
End Sub
However, my goal is to make the calendar appear when I click on cell B2.
I tried using the following code, but when I click on B2 nothing happens.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "\$B\$2" Then UserForm1.Show
End Sub
I also tried:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
With Worksheets(ActiveCell.Worksheet.Name)
If ActiveCell.Column = 2 Then
If ActiveCell.Row = 1 Then
UserForm1.Show
End If
End If
End With
End Sub

## Hide The Formulas & Change The Attributes

Sep 4, 2009

First, to i change the attributes, select the appropriate cell or range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden (or both). Unlock cells that accept user input, and lock formula and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells: The results of the formulas will be visible, but the formulas will not.

Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. but its hideing the formulas. once i protect the cells it wont let me to edit the worsheet (eg- cell height, cell width)

## Replacing One Cell With Another And Controlling Its Attributes

Jan 24, 2010

1) What function can I use to replace a specific cell in spreadsheet 2 with what I type in a specific cell in spreadsheet 1 (e.g. type red in spreadsheet 1 in A1 and it will replace a blank cell A1 in spreadsheet 2 with red)? I have around a hundred spreadsheets which I need to name by typing a name in cell A1. Rather than doing this, I already have the names of the spreadsheets in a column.

2) Is there anyway to control the attributes of cells in another spreadsheet? E.g. change to bold, red and specific size font in cell A1 in spreadsheet 2 using cell A1 in spreadsheet 1.

## Using A Lookup Based Upon Cell Attributes

Mar 2, 2007

Lets say that you have three cells. The contents of the cells are 1, 2, 3. The contents 1 and 2 have the strikethrough and 3 does not.

How can you perform a lookup from within another cell to find the cell whose content does not have the strike through? (This could also be a search based on finding the cell that does not have the red background etc...)

## Adding Value Based On Cells Attributes?

May 10, 2012

I'd like to sum up values based on certain cell attributes. Firstly, I don't know if it's possible to define cell attributes and how to do it. Let me put some example:

I have one column where I've put some values and I'd like to sum up the values only for certain cells in this column. In an "OOP approach" I'd use some grouping method based on attributes, so each cell would have an attribute called ID, for example, and I could select only the cell with some desired ID.

Feb 5, 2007

Are the 2 examples the correct methods to prevent right-click on Rows and Columns?

'Prevent Right Click on entire selected Row(s)

Application. CommandBars("Row").Enabled = False

'Prevent Right Click on entire selected Column(s)

Application.CommandBars("Column").Enabled = False

## Count Based On Intersecting Attributes

Jan 23, 2008

I have a list of items in a tab of a workbook that has attributes across the top, with an X in the intersection if the item has that attribute. For example:

Items:
Apple
Table
Paperclip

Attributes:
Red
Wood
Small

The Apple might have an "X" in the intersection of Red and Small, and the Table might only have an "X" in the intsersection with Wood.

I have another tab with five drop downs that can either be blank, or one of the attributes. I want to create a formula that will return the number of items in the list that have an "X" for all the attributes selected in the drop down. Therefore if I selected only "Small" and left the other four blank, the formula might return 2, and if I then select the next drop down and select "Red" the formula would now return 1.

Any thoughts of how I could accomplish this? I am thinking of using a SUMPRODUCT and some sort of Index Match to find the value in the cells selected by the drop down. It seems like Index only returns a row though, and not a column.

## Conditional Formatting Which Makes The Cell Green

Mar 4, 2009

See attached document. In cell G4 i need a format which will make the cell green, amber or red depending on the values in Cells I7 to I9.

3 Greens = Cell G4 to be green
2 Greens, 1 Amber = Cell G4 to be amber
2 Greens, 1 Red = Cell G4 to be red

## Set A Conditional Formatting Rule That Makes A Cell Red?

Jan 9, 2014

I want to set a conditional formatting rule that makes a cell red or green depending on if the value in the cell is larger or smaller than the value in another cell +2% or -3%. If neither of these conditions are met no formatting should be applied..

a) In the cell (R104) where the condition is set I have the following formula:
=if(BP104=0;"";BQ104/BP104) (the values in BP104 and BQ104 is retrieved from a database)

b) The conditions I've set in R104 are the following

1) =isblank(\$R\$104) (condition: "nothing")

2) =\$R\$104<\$R\$106-0,02 (condition: "red")

3) =\$R\$104>\$R\$106+0,03 (condition: "green")

c) In cell R106 the value there is a value of 90%

The conditions seem to work fine when the value in R104 is higher or lower than the conditions set in 2 and 3 above but when the value is blank in R104 the cell goes green, which it shouldn't.

## Rounding Function That Makes The Resulting Zero A Dash

Feb 24, 2009

I am importing a .txt file into Excel that has two columns of dollars and cents. When I do my subtotals, all subtotals should be zero. Some of the totals show as 0.00, some as (0.00) and some as a dash which is what I would like for all of them. I have tried: ...

## Picking Up Image Attributes From Folder File

Jan 26, 2010

I want to do in VBA is to be able to read and place in a variable the image Width and Height of an image in a folder. I can (with help from here) read the filenames in folder. But is there a way in Excel to read the above attibutes?

## Access The Full Set Of Attributes For Controls In A Group

Feb 19, 2010

How to access the full set of attributes of a control when grouped?

I am trying to access the properties of a grouped set of checkboxes (for grouped I mean selected and right click - > Group)

It appears that grouped controls are not accessible through OLEObjects() but they can be accessed as shapes. For example, the following code will set all elements in the group Advertisement2 to .Visibility = False:

T.Visible = True
Next
However, most other properties, such as .Enabled or .Value are not accessible (probably because the controls are considered shapes).
I have tried all sort of solutions, including using
.groupItems("ControlName").Value
or
.groupItems("ControlName").Object.Value

## Pull Data And Makes Changes From Different Tabs Using Dropdown List?

Jan 4, 2013

I have an (organization) work book that contains departments in different tab with each department having its own tab. In each tab is the employee name, dept manager, dept number and emp number. In the CoverSheet (main sheet) I want to put the department numbers in a drop down menu.Upon selection of a department number i want to Look in the whole workbook to see where the department number is, pull up the department head and all the employees in that department with their employee numbers

The reason for this is that I want to be able to add a button to delete/edit to be able to edit employee details centrally from this particular (CoverSheet) sheet and update the relevant sheet.

Also put in an input box to add employees and update the relevant tab (department)

## Identify Minimum Combination Of Columns Which Makes Row Unique?

Nov 20, 2013

I have a (phylogenetic) matrix with a species in each row, and morphological character in each column, scored as 0, 1, 2, 3 or 4 for each different species, so something like the following but much bigger:

Character 1 Character 2 Character 3
Species A 1 0 1
Species B 3 2 2
Species C 1 2 0

I want to identify the minimum combination of different columns (i.e. their values, but also which columns) that make a particular row unique.

## IsBlank In VBA: Check That Makes A User Insert An Integer Between 0 And 90

Aug 28, 2009

Trying to design a check that makes a user insert an integer between 0 and 90. So far I can use this: