Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
I need help creating a formula. I would like to see the increase in one
line ot the next in a column to the right. So line one is 2.12877 line two is 2.12218 and beside that amount in the next column have it say - ..00659 and so on. can anyone help? 2.12877 CAD 2.12218 CAD - .00659 2.12547 CAD 2.09009 CAD 2.11687 CAD 2.12578 CAD 2.10711 CAD 2.09477 CAD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
Based on your sample data in which all the numbers are 7 characters:
=LEFT(A2,7)-LEFT(A1,7) Biff "Zilla" wrote in message ups.com... I need help creating a formula. I would like to see the increase in one line ot the next in a column to the right. So line one is 2.12877 line two is 2.12218 and beside that amount in the next column have it say - .00659 and so on. can anyone help? 2.12877 CAD 2.12218 CAD - .00659 2.12547 CAD 2.09009 CAD 2.11687 CAD 2.12578 CAD 2.10711 CAD 2.09477 CAD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
Zilla wrote:
I need help creating a formula. I would like to see the increase in one line ot the next in a column to the right. So line one is 2.12877 line two is 2.12218 and beside that amount in the next column have it say - .00659 and so on. can anyone help? 2.12877 CAD 2.12218 CAD - .00659 2.12547 CAD 2.09009 CAD 2.11687 CAD 2.12578 CAD 2.10711 CAD 2.09477 CAD Hi Zilla, assuming that the first one (2.12877 CAD) is in A2, fill the following down to the row with the last one... =VALUE(LEFT(A3,LEN(A3)-4))-VALUE(LEFT(A2,LEN(A2)-4)) Ken Johnson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
You could also try a custom number format (Format/Cells/Custom - enter
0.##### "CAD" in the text box that appears. when you enter 2.12877, it will show as 2.12877 CAD, but the value in the cell will still be a number, so =A3-A2 You would have to remove the " CAD" from your data which could be done with Find/Replace. Find " CAD", Replace with nothing. Just be sure to backup before experimenting. "Zilla" wrote: I need help creating a formula. I would like to see the increase in one line ot the next in a column to the right. So line one is 2.12877 line two is 2.12218 and beside that amount in the next column have it say - ..00659 and so on. can anyone help? 2.12877 CAD 2.12218 CAD - .00659 2.12547 CAD 2.09009 CAD 2.11687 CAD 2.12578 CAD 2.10711 CAD 2.09477 CAD |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
Do you see any problem if we take out VALUE? The formula seems to work fine without it.
Epinn "Ken Johnson" wrote in message oups.com... Zilla wrote: I need help creating a formula. I would like to see the increase in one line ot the next in a column to the right. So line one is 2.12877 line two is 2.12218 and beside that amount in the next column have it say - .00659 and so on. can anyone help? 2.12877 CAD 2.12218 CAD - .00659 2.12547 CAD 2.09009 CAD 2.11687 CAD 2.12578 CAD 2.10711 CAD 2.09477 CAD Hi Zilla, assuming that the first one (2.12877 CAD) is in A2, fill the following down to the row with the last one... =VALUE(LEFT(A3,LEN(A3)-4))-VALUE(LEFT(A2,LEN(A2)-4)) Ken Johnson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating formula help
Epinn wrote: Do you see any problem if we take out VALUE? The formula seems to work fine without it. Epinn Hi Epinn, I agree, I was being over-cautious and sloppy at the same time. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Creating a complicated formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
Creating a specific formula | New Users to Excel |