| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I write a formula in Excel
I have been at this for a long time and I know I have to be missing something
small, hopefully small, this is what I am trying to do for a work spreadsheet when costing some jobs, I need to use vlookup which is working but not fully, I need a formula to say, If the date is <9/20/2005 then look up the rate in the column 1, but if the date is greater then 9/20/2005 then look up the rate in column 2, it is looking up the rate but when the date is changing it does not change the formula to the correct rate. PLEASE HELP!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
| Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
