i need a formula for an excel word sheet that i can work easily on it.?

Question

i want to prepare a excel sheet in which i want to prepare three columns. one for number of days served, one for the rate and last one for the amount. i want to set a formula like that if i will enter the figure from 1 to 9 in the days column, the rate will come 3.75 automatically, if i will enter 10 to 19 in days column, the rate will come 7.50 automatically and if i will enter the figure from 20 to 31 the rate will come 15 automaticaly. is it possible. if anyone can help me, plz help.

Answer 1

You could use an "IF" statement for the rate column. Here is an example where A1 is the "days" cell.

=if(A1<10,3.75,if(A1<20,7.5,
IF(A1<31,15,"error")))

This would be an easy way of doing it. Basically an IF statement is setup like this:

=IF(test,answer if yes,answer if no)

If cell A1=5, The following formula: =if(A1=5,1,0) would return a value of 5. Excel Help will explain this better. The first example is a nested if statement.

Answer 2

You did not describe the third column (Amount) so I assume it is supposed to be =(Days*Rate). That formula would be easy, =(A2*B2). The other would probably best be done with VLOOKUP.

Setup a simple array, off to the side or even on another sheet.

1 - - - -3.75
10 - - -7.5
20 - - -15

I always name my ranges, it makes formulas easier to read, for this sample I named the array "Rate."

So, now we have 3 columns; Days, Rate, and Amount.

—Days, obviously, is where we input the days served.

—The formula for the Rate column is:
=IF(A2=0, 0, IF(ISNA(VLOOKUP(A2, Rate, 2)), "", VLOOKUP(A2, Rate, 2)))

—Lastly, the formula for the Amount column is =(A2*B2)

Answer 3

MS puts out excellent books on using Excell. Go to a local book store, preferably a college bookstore! The formulas are very complex, but once you learn them, their pretty easy. I could help you, but don't quite understand what it is your trying to do!
Try clicking in row 1 and entering your formula there, but if you don't have the (,),*'s just right, it's gonna reject ya!
Maybe "Staples" or "Office Depot" has the books. I sold mine back at the end of the semester! Sorry...

Answer 4

you are able to load the information from Excel quickly into get entry to - load sheet one million into one table and sheet 2 right into a separate table. Then use the question wizard to position in writing an elementary question to grant you the answer you favor. an option determination may be to position in writing a macro in Excel to do the analyze for you. yet for my area it somewhat is slightly more suitable complicated because it contains writing macro code - yet in case you do not have get entry to it really is an option. wish that permits!