Archive

Posts Tagged ‘formula help’

Quick Excel Formula Help

December 21st, 2011 Comments off

Hi, I have an excel formula that I need to add to as well as condense or make smaller if possible.

Here’s what I want:

IF Cell B2 = “anklets” then run the formula below. IF not, do nothing.

IF(COUNTIF(C2,”*bead*”)>0,”1015683″,IF(COUNTIF(F2,”*bead*”)>0,”1015683″,IF(COUNTIF(C2,”*crystal*”)>0,”1016581″,IF(COUNTIF(F2,”*crystal*”)>0,”1016581″,IF(COUNTIF(C2,”*gemstone*”)>0,”1016581″,IF(COUNTIF(F2,”*gemstone*”)>0,”1016580″,”1016553″)))

Is it possible to make this formula…

Categories: Excel, Quick Tags: , , , , , ,

Excel Formula Help

September 27th, 2009 Comments off

I need an excel formula that does the following:

Takes a time stamp like “2009-03-01 15:00:00″ and counts the days from this date to today.

so for example if the time stamp is 2009-09-27 15:00:00 and today is the 28th, the next column over will say 1.

Needs to work no matter what the year or month is in the time stamp and needs to scale to unlimited entries.

Categories: Programming Tags: , , , , , ,
Bear