I recently saw a pop music quiz using Excel.  The photos of bands were in
the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks

My formula below retunrs "0" because this year, I think "12" refers to
December 2008. The formula below was to produce December 2007.
Please edit the formula below so it can produce December 2007 and/or
December of ANY year that I will select in the future.

Have checked to ensure cell is formatted as General, not text, but still
Control + Shift + Grave Accent doesn't toggle - I'm still viewing formula
rather than result.
Control + Grave accent (without shift) makes all the columns in the

I have a column that contains different terms seperated by Comma.
Similar to "Apple, Ball, Cat,Dog, and so on".
I have upto 15 unique values that could be there and different rows
have different number of values. Some rows have no values, some can

I need to sum multiple columns based on the value in one column and
the excel formula I used below always evaluates to 0 and I can't
understand why?
=SUMIF($AC$155:$AC$334,C62,$AM$155:$AR$334)

Basic question: I am trying to write a macro that looks to see whether A1 =
"X" and also if any of A2...10 = "Y", then Statement A, else Statement B.
Thank you in advance.

I've subtracted two dates and now I want to do a IF statement. Do I have to
convert to numeric to do that? It's not bringing up correct values. At this
time H7 equals :45. How do I get the formula to work?
=IF(H7<=35,"On Target","Not on Target")

I've setup a spread sheet with everyother line colored to highlight the
information.  However if I go to change the data in search of something the
line color follows the information.  I've tried making a template and setting
the line color but that doesnt work for me either.  Is ...

Hi everyone,
Is there a way to enable the sorting feature in Excel when the worksheet is
locked?
Thanks,

I am working on a time sheet that had one other/code column.  In the debit
column, there was an if function( if(I7="c",h7,"")  So if the code =C, it
automatically went over to the debit column.  We have added an additional
column because sometimes employees might take 2 hrs c ...

I would like to change a field a different color depending on the IF
statement being True or False. Anyone know if I can do this in Excel?

Pseudo-Follow-Up to my last question:
Going based on the below example, how can I write a formula that will give
me a count of the total lines that meet this criteria: Name--Dog, Male--Y,
Brown--Y, Size--Big, ID # only 1, 2, 3, 5, 7, 8, 15, 16.  So, in the case

Is there a function that causes the current date to appear in a cell whenever
the worksheet is opened?

Gang,
I have the following iserror formula:
=IF(ISERROR(IF(G36="","",(1-(IF(Inputs!B7=FC,
(HLOOKUP(reporting_period,Cost!$I$427:$HI$434,(MATCH('Deloitte

I have a column in a table with data (A1:A5).  Each of these numbers needs to
be multiplied by a row in another table (A1:E1).  I need the sum of A1*A1 +
A2*B1...+A5*E1.  
Basically I am trying to get the sum of multiples in an array that are of