Custom List Message Item  

Hi. I'm trying to create a point based fitness log system where with each workout you earn points and with the points earned you level up over time.
My issue is what would be the best way to do this besides using the "IF" function?
Thanks. Read MoreTo get a level from a list of steps, first create a little table that looks similar to this:
(lets assume this is on Sheet2 ... Read More  
Hey,
I am tracking the number of falls for about 100 people, but need to know how many falls each have had in the last 6 months. I would like for this number to automatically update with the current date.
I have the months set across C1:N1 and the people ... Read MoreSend that excel file.
Or give an example.  
In cell B5 it currently says 3 Foot. In different scenarios it can also say 6 Foot or Even. I need cell C7 to reference the appropriate column on tab 1C in regards to Even, 3 Foot, or 6 Foot, then I need it to reference the corresponding number in cell ... Read MoreHi John
It's better to provide a workbook than a bunch of photos.
 
This is probably easier than I think but at 4:30 in the morning not thinking clearly.
Does not work, remember, the ID values occur multiple times with different conditions and I want to identify ID's only where both conditions are true, not ID's where eith...
Read More
 
Below is the function I'm using to track the overall weight loss percentage of members over a 12 week period. The problem is that, say the result for (D3E3)/D3 is .045, or 4.5%, the result of the ifs function shows 1.045, or 104.5%. Please advise on how ... Read MoreHi Chelsea,
In your expression you have sum of two functions, IF and IFS. IFS itself shall give correct result, i guess +1 is added by IF. Your rewritten expression look ... Read More  
I would like to create two dropdown lists. One dropdown list would contain the type of Dessert (see below  Ice Cream, Cookie, Jello. In the second dropdown list, I would like the user to only be permitted to select the flavor associated with the desse ... Read MoreHi,
The solution is as follows:
In the first dropdown list:
In the second dropdown list, put this formula in the data validation source: =IF(D2="Ice Cream",B2:B4,IF(D2="... Read More  
I have a Table (obviously), one column (B) is labeled "Status" and is limited to a data validation list; the next column to be considered in this question is column (D) which is labeled "Date Used" into which is to be entered a date.
The problem I am expe ... Read More
FORMULA in cell B2
=IF(D2<>"","USED","UNUSED"). Although CF will work it doesn't necessarily means the user will necessarily select the correct option. Automating the colu... Read More Hello Russ
You can set up a data validation in column D so that a date can only be entered the text in column B is not equal to "Unused".
Or you can set up a conditional ... Read More  
Hi, I am trying to create a formula for my share trading spreadsheet (I just added a comment in here but I think I deleted it somehow :( If I trade 1 contract the commission paid is $4.25, if I trade more than 1 contract the commission is $0.85 per additi ... Read MoreHI Anthony
Lets assume the number of trades is in cell A1 then your formula is
=IF(A1=0,0, 4.25+(A11)*0.85)
so IF 1 contract is sold it will be $4.25 + (11) *0.85 so IF ... Read More  
Hi, I'm trying to create a formula for my share trading spreadsheet. It is to calculate the commission paid per contract traded. If there is only 1 contract the commission is $4.25, if more than 1 contract it is an extra $0.85 per contract What I'd like to ... Read More  
Hello,
I'm having a little struggle with something that I think it can't be so hard.
I have two blocks of 6 columns each. What I want to do is to make a rule for the first block. I want to color the first block depending on different conditions. If the divi ... Read MoreHello,
I'm not quite sure I understand your requirement completely. For the first column, fine. But the second column, should that compare the first column of the blocks, ... Read MoreBest Response
 
I'm trying to extract a bunch of specific text combinations from cells and present it in a new cell. This formula seems to work for two variables but I can't add any more variables too it. =IFERROR(IF(SEARCH("*Sales*",B3,1),"Sales"),IF(SEARCH("*Arch*",B3,1) ... Read MoreHi Reuben Helder,
Good day,
Please refer below formula to add more variable. If statment is false then I have considered criteria is "NO MATCH" IF(B3="MECH","MECHANICAL",IF ... Read MoreDear Reuben Helder, Ah, a classic one.
Key words in column F, returned text in column G, text to check in A1.
=LOOKUP(PI(),1/COUNTIF(A1,"*"&$F$1:$F$6&"*"),$G$1:$G$6) Read More  
Hi,
I am trying to referance a cell within a column to another cell. The column contains a list that I need to chop and change and often delete individual cells with it. If I delete a cell the problem is I get a REF! error in the cell I want the text to a ... Read MoreHi Aoife,
you might be able to use lookup functions, such as VLOOKUP or INDEX/MATCH in case you have a reference column for the purposes of lookup. Are you able to post a ... Read More  
Dear community, Hi Daan,
For conditional formatting use the rule =($C3<=0.8*$C$11) and apply it to $B$3:$B$10
 
I have a rather ragged data set, which is split over three sets of columns. In columns A, H and O I have multiple instances of the same numbers representing sample codes. In the other columns I have individual attributes which have been scored out of 100. ... Read MoreHi Terri,
in line with the approach referred to by Jon, your formulas would be as follows:
Median: =MEDIAN(IF($M$2:$M$76=$M$78,$N$2:$N$76,""))
STDEV: =STDEV(IF($M$2:$M$76=$ ... Read MoreYou could try an array formula using MEDIAN(IF(),IF(),IF()) and STDEV(IF(),IF(),IF()) as explained here:
http://stackoverflow.com/questions/6752724/helpneededwithmedianifinexcel ... Read More  
I've recently seen a few posts on various sites with people requiring assistance in devloping dependent drop downs.
I have a budget tracker. once i record an expense, I have drop down list for the categories they fall into. however, once I select the drop down menu, I want the amoun ... Read More
I have created several tutorials on this topic which can be found here  http://www.contextures.com/excelfilesRoger.html For those with XL2007 upward, I would recommend t...
Read More
