Archive

Posts Tagged ‘excel formula’

Excel Formula

January 20th, 2012 Comments off

I will require 1 quick excel formula. nothing fancy just an equation, that will serve 2 purposes.

There will be several variables that I will be need to be able change. (min, max, etc)

1) Based on the variables I enter, a graph will be generated

2) The formula will then generate a value,and plot it on the line generated on the graph.

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…

Excel Formula 2

October 21st, 2011 Comments off

Robert, I am attaching the excel sheet for you to work with.

What I need:

A working excel sheet with the formula that lets me do the following:

If g2 = Earrings-Hoops then print what’s in a2,b2,c2,d2,e2,f2,g2 into I2,j2,k2,l2,m2,n2,o2

This will help me build my list of all the earrings-hoops category. :

Categories: Excel Tags: , ,

Excel Formula

October 11th, 2011 Comments off

I need a formula to insert a text/word in a cell after a number of words
For exemple:

Column A
xxxxxx
tttttt
yyyyyy
eeeeee
kkkkkk
wwwwww

Column B
The area now called England was first
inhabited by modern humans during the
Upper Palaeolithic period, but it takes
its name from the Angles, one of the Germanic
tribes who settled during the 5th and 6th centuries.
England became a unified state in AD 927, and since

I need a formula that will allow me to add a word/text after 3 words.

So column C (RESULT) should look likr this:
———————————-

The area now xxxxxx called England was first
inhabited by modern tttttt humans during the
Upper Palaeolithic period yyyyyy, but it takes
its name from eeeeee the Angles, one of the Germanic
tribes who settled kkkkkk during the 5th and 6th centuries.
England became a wwwww unified state in AD 927, and since

You will receive $10 and a good review

Imacros And Excel Formula

September 5th, 2011 Comments off

Looking for imacro scripts for real estate bpo forms, usres, resnet, farvv, m2m, possible other scripts you may have for bpo companies

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.

Imacros And Excel Formula

July 9th, 2009 Comments off

I need a macro written that will take the information off of an excel spreadsheet (csv) and import it into an online form in the correct fields. Please feel free to send me an email for further information regarding this project

This should not be a tough job for someone that knows what they are doing.

Imacros And Excel Formula

June 4th, 2009 Comments off

I need A Macro written that logs onto a website and runs a report. The Macro can cycle through a list of states and run for each state. The report can be right-clicked and exported to excel. The Macro will have to do this.

When the reports are downloaded to excel it would be great if they could be in seperate tabs.

Then an excel formula will need to be written that: It can be an index/match/vlookup that goes and pulls interest rates for a particular city and state from the downloaded date.

This should not be a tough job for someone that knows what they are doing.

Excel Formula Work 3

April 2nd, 2009 Comments off

I require an excel expert to help me calculate a bill.

On the first sheet(billmax) it will have all of the formulas and totals.
I’ve already created the layout of the totals but will need the formulas and macros to retrieve the right amount for the bill.

The totals will be calculated from a bill that is provided on the next excel sheet.

Suit someone with advanced knowledge in mathematics and excel.
Most of the work is done, you just need to finish this off.

just updated the excel sheet at http://automax.tv/joini3.xlsm

what will happen is the first sheet will list the totals.
There are 5 telephone plans that take the values from
b12 to k23.

These values determine the cost of the bill.
Now the bill values come from sheet1. These has the types of calls , stds, locals.

So the first sheet will need to call the third sheet and any sheet that is added.
The main values are the
1) Call type
2) Duration
3) Time of call
4) Some calls are timed in 30 second and others in 1min block.
5) Need if formulas if duration is past an amount.

The goal of the project is to insert a bill(copy and paste) and then calculate which plan will save the most money.

Need someone to start today and finish by tomorrow.

Excel Formula Work 2

April 1st, 2009 Comments off

I require an excel expert to help me calculate a bill.
The first guy didnt have the skills to finish.

On the first sheet(billmax) it will have all of the formulas and totals.
I’ve already created the layout of the totals but will need the formulas and macros to retrieve the right amount for the bill.

The totals will be calculated from a bill that is provided on the next excel sheet.

Suit someone with advanced knowledge in mathematics and excel.
Most of the work is done, you just need to finish this off.

just updated the excel sheet at http://automax.tv/joini3.xlsm

what will happen is the first sheet will list the totals.
There are 5 telephone plans that take the values from
b12 to k23.

These values determine the cost of the bill.
Now the bill values come from sheet1. These has the types of calls , stds, locals.

So the first sheet will need to call the third sheet and any sheet that is added.
The main values are the
1) Call type
2) Duration
3) Time of call
4) Some calls are timed in 30 second and others in 1min block.
5) Need if formulas if duration is past an amount.

The goal of the project is to insert a bill and then calculate which plan will save the most money.

Need someone to start asap and finish soon.

Excel Formula Work

March 31st, 2009 Comments off

I require an excel expert to help me calculate a bill.

On 1 sheet it will have all of the formulas and totals.
I’ve already created the layout of the totals but will need the formulas and macros to retrieve the right totals.

The totals will be calculated from a bill that is provided on the next excel sheet.

Suit someone with advanced knowledge in mathematics and excel.

Bear