Question about Microsoft Excel for PC

# WRITING A LONG IF AND THEN FORMULA

I have several if and thens that i need to put into a formula per line. Can not get it to take it. I have wrote these formulas for years but got vista and now having problems

Posted by on

• sulney Oct 06, 2008

i have columns of data where i wish to take information from one then the next and so on but that which relates to the person in column 1 who may appear there on numerous occasions.

• shujat_hussa Nov 08, 2012

please visit to learn all excel functions and formulas All-in-One Excel Functions and Excel Formulashttp://atips4pc.blogspot.com

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotÂ 5 achievements.

Governor:

An expert whose answer gotÂ voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

The OS should not impact on the performance of Excel..
Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.
The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.
Have you exceeded this limit ??

Posted on Aug 17, 2008

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### I have a vehicle which have moved for 2383 kilo meters and used 320 liters of diesel what should be the consumption rate

school work you should solve by yourself... not by fixya...

you have following data:
v = volume = 320liters
d = distance = 2383km (kilometers is a single word...)

there is several formula to solve this mathematical problem, if you want how many liters per 100km formula is as follows:
(v/d) x 100 = 100km/ltr just substitute your data

if you hear then that vehicle is using 7.5ltr/100km that was the formula. unfortunately - you need to calculate your own data, this was just an example...

another variation is distance per liter, there is formula:
d/v = distance (kilometers) per liter

if you hear that car is driving 11km/ltr - that is again, and example, you need to calculate your own data...

enjoy! and vote...

Feb 10, 2015 | Haier DWL3525DDBB 24 inch Built-in Tall...

### How can I properly determine the amount of watts per gallon of lighting I need for my aquarium?

How many watts you need depends on the type of plants and the volume of the tank. Here is an excerpt from an article that will help you determine proper wattage.
Instructions

Identify the species of plants you have in your tank or that you plan to put in your tank and how much light that species needs. Each species of plant will have an optimal lighting requirements, from low light to bright light. To determine the plant species, compare photos on the Aquarium Plants Photos and Profiles page of the Aqua Hobby website, or take samples of the aquatic plants to your local aquarium store for identification.

Write down how much lighting each of the plant species in your tank needs. Give each plant a rating of low, medium or bright. The books "The Complete Fishkeeper" and "Freshwater Aquariums for Dummies," as well as your local fish store, are good sources of information for this.

Review your list and determine what type of plant dominates your tank. For example, if you have mostly plants that need bright light, then use a bright-light formula. If you have an equal mix of plant lighting needs, then use a medium-light formula.

Calculate a range of watts of lighting you need for your tank with one of the following formulas, depending on the amount of light you determined you needed for your plants. For low light, multiply one and two by the number of gallons. For medium light, multiply two and three by the number of gallons. For bright light, calculate three and five by the number of gallons. For example, for a 20-gallon tank with plants that need medium light, you would get a range of 40 to 60 watts (2 x 20 = 40 and 3 x 20 = 60).

Aug 14, 2012 | Fish

### I want to have the source codes for printing diamond shape asterisk in visual basic

I am pretty sure I got this as a homework assignment in programming class. If I had someone give it to me then I wouldn't be even the limited programmer I am now. That said, I will help, but I will not give you the full out answer.

1. The number of stars and characters per line are an odd number to make the ASCii look like a diamond. For my example, the maximum number of characters per line is five.
2. Create a variable called dia_star that will hold the spaces and stars. To figure out the number of spaces that should be put into each star line, use this formula:
number of spaces per star = ( max number of characters per line - number of stars) / 2
dia star = number of lines before star and "*"
print dia star

1. --*--
2. -***-
3. *****
Good Luck,

NOLA Tech

Jan 30, 2010 | Microsoft Visual Basic Enterprise Edition...

### Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

### Excel formula,

the basic idea of an if statement is just that if this then that. Thus a formula could look as simple as =IF(A2=1,25,IF(A2=2,10))

Jan 10, 2009 | Computers & Internet

### Microsoft excel

this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

### Print source code of an Access Database

Hello cbw@netzero.com,

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Oct 06, 2008 | Microsoft Office Professional 2007 Full...

### If formula

What are the "cases"? Your example "more then 8 or less then 9 use 400" implies that there is a decimal part e.g. 8.5 . Is that right?

You dont need to test in both directions
e.g. assuming you name the cell with your number in it "cases"
=if(cases<9,400,if(cases<10,410,if(cases<11,420,430)))

Aug 07, 2008 | Microsoft Excel 2000 Step by Step...

### Excel formula.....

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

### How to write a Formula

Suppose your Basic Amount is in cell A5 then write a formula in B5 - If(A5*0.3>5000,5000,A5*.03) and copy this formula to all cells in coloumn B .

Oct 12, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

112 people viewed this question

Level 3 Expert

Level 3 Expert