Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I'm looking to calculate the differnce between two numbers, Say I have 24
in a columnand next to it in the next column I have 25, I would like it to show the differnce of +1 in the next column. Then say the next row down it has 30 in the first column and 25 in the next it would be a differnce of -5 and so on. Wouls also like the cell to be highted with a colour if its a + number and a differnt colour if its minus. If both numbers are the same then would like a 0 and no colour. Hope you can understand what I'm looking for. I can get it to say true or false but not to show the difference. Hope someone can help me. -- Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Difference between three numbers in percentage | Excel Discussion (Misc queries) | |||
% of difference between two numbers | Excel Worksheet Functions | |||
difference between 2 numbers | Excel Discussion (Misc queries) | |||
Finding the difference between two numbers | Excel Worksheet Functions | |||
Show % Difference between two numbers | Excel Discussion (Misc queries) |