![]() |
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? |
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? |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com