| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between 2 numbers
Probably being dense but how can I get excel to look at two sets of figures
one from last year and one from this year and then give me the difference if there has been a gain or the lowest figure -ve if there has been a loss (last years and this years may both be a loss in some cases - nb not financial figures -- Thank you Annie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difference between 2 numbers
you could try something along the lines of:
a1 = last year # b1 = this year # =if((b1-a1)0,b1-a1,min(a1,b1)) george "Annie" wrote: Probably being dense but how can I get excel to look at two sets of figures one from last year and one from this year and then give me the difference if there has been a gain or the lowest figure -ve if there has been a loss (last years and this years may both be a loss in some cases - nb not financial figures -- Thank you Annie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difference between 2 numbers
Not clear what you want. Try giving a couple of examples.
-- David Biddulph "Annie" wrote in message ... Probably being dense but how can I get excel to look at two sets of figures one from last year and one from this year and then give me the difference if there has been a gain or the lowest figure -ve if there has been a loss (last years and this years may both be a loss in some cases - nb not financial figures -- Thank you Annie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
difference between 2 numbers
Not quite but thank you! :-)
-- Thank you Annie "mopgcw" wrote: you could try something along the lines of: a1 = last year # b1 = this year # =if((b1-a1)0,b1-a1,min(a1,b1)) george "Annie" wrote: Probably being dense but how can I get excel to look at two sets of figures one from last year and one from this year and then give me the difference if there has been a gain or the lowest figure -ve if there has been a loss (last years and this years may both be a loss in some cases - nb not financial figures -- Thank you Annie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the difference between two numbers | Excel Worksheet Functions | |||
| Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
| Find all possible Difference between two sets of numbers | Excel Worksheet Functions | |||
| Finding the percentage difference of two or more numbers | Excel Worksheet Functions | |||
| calculating the difference between 2 numbers | Excel Worksheet Functions | |||
Linear Mode
