| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two columns , and giving comparison results in a third.
Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. Best Wishes |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a third.
=IF(C2A2,"+",IF(A2C2,"-","="))
-- David Biddulph Colin Hayes wrote: Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a third.
=IF(C3A3,"+",IF(C3<A3,"-","="))
Regards -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "Colin Hayes" wrote: Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. Best Wishes |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a third.
Try this:
=IF(C1A1,"+",IF(C1<A1,"-","=")) Copy down as needed. -- Biff Microsoft Excel MVP "Colin Hayes" wrote in message ... Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. Best Wishes |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a thi
Of course, it states C3 and A3 but that is because thats where I proved the
code. Put =IF(C1A1,"+",IF(C1<A1,"-","=")) In Cell D1 and copy (Drag) down as many rows as you need. Regards -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "MikeJohnB" wrote: =IF(C3A3,"+",IF(C3<A3,"-","=")) Regards -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "Colin Hayes" wrote: Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. Best Wishes |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a third.
Hi,
Suppose your result column is D then enter =C1-A1 in cell D1, copy this formula as far as necessary and then choose Format, Cells, Number tab, Custom and enter the following custom format on the Type line +;-;= -- If this helps, please click the Yes button Cheers, Shane Devenshire "Colin Hayes" wrote: Hi All I have small request for assistance. In Column A , I have a row of numbers. In column C I have a row of numbers too , with a formula underlying each. I need , in column D , for the numbers in A and C to be compared and a plus sign to be placed in the cells where C is bigger than A , a minus where C is smaller than A , and an equals sign where C is the same as A. Can someone help on this , please? Grateful for any assistance. Best Wishes |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing two columns , and giving comparison results in a third.
In article , Shane
Devenshire writes Hi, Suppose your result column is D then enter =C1-A1 in cell D1, copy this formula as far as necessary and then choose Format, Cells, Number tab, Custom and enter the following custom format on the Type line +;-;= HI OK thanks for all your assistance and expertise. It's fixed now. Best Wishes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRUNC zero giving odd results? | Excel Worksheet Functions | |||
| Very large workbook now giving incorrect results :( | Excel Discussion (Misc queries) | |||
| Very large complex workbook is now giving me the wrong results :( | Excel Worksheet Functions | |||
| Comparing contents of two spreadsheets and outputting results to a | Excel Worksheet Functions | |||
| Equation giving unexpected results | Charts and Charting in Excel | |||
Linear Mode
