Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Help machin up numbers
I have a list of numbers, this list has positive numbers that are being write
of by a same negative number, this is 156.35 to -156.35 I need to show all the positive numbers that have a match as 0, the rest of none match as it is? |
#2
|
|||
|
|||
Hi
not sure what you want to happen here what is the cell reference of 156.35 what is the cell reference of -156.35 where do you want the 0 if you want to change the 156.35 to 0 what do you want to happen to the -156.35? Cheers JulieD "MESTRELLA29" wrote in message ... I have a list of numbers, this list has positive numbers that are being write of by a same negative number, this is 156.35 to -156.35 I need to show all the positive numbers that have a match as 0, the rest of none match as it is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |