WRITING A LONG IF AND THEN FORMULA

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...

The answer is yes.

The acceleration due to gravity is approximately 32 feet per second or 9.8 meters per second. If you're measuring the distance in feet use 16, if you're measuring in meters then use 4.9.

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).

Read more: How to Determine Watts Per Gallon for Aquarium Lighting ' eHow.com http://www.ehow.com/how_8014286_determine-per-gallon-aquarium-lighting.html#ixzz23KB8HErA

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

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.

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.

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)))

Need more information on what the numbers are to help further

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.

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 .