I am using Excel 2003 and having trouble figuring out the formulas. What I am

trying to do is add a total of 6 cells in a row. Each cell has a different

formula that comes up with a certain value once all cells are added together.

Example:

cell A= inserted value*10

cell B= inserted value*2

cell C= inserted value

cell D= inserted value*5

cell E= inserted value*3

cell F=inserted value/20

In cell G, I want to add cells a through f except that cell f has multiple

"if then" statements.

Cell f: if inserted value/20 <10 then I want to add a

number to the sum of cells a through e

if inserted value/20 is between 11 and 15 I

don't want to add a certain number to the sum of cells a through e

if inserted value/20 is between 16 and 20 I want

to subtract a certain number to the sum of cells a through e

Anyhelp on this is greatly appreciated! Hopefully I explained what I want to

do without confusing everyone as much as it's confusing to me

## Bookmarks