Replacing Numeric Values With Text
Posted by Lee Hitchen on November 25, 2001 9:19 AM
Is it possible to replace numeric values in a range with "y". I don't appear to be able to use global replace to do this ie Replace: ">0" with "y". Any suggestions please?
Regards
Lee
Posted by Lewis on November 25, 2001 10:01 AM
Hi,
I use the following formula to show negative and positive numbers. Admittedly in a separate column.
=IF(J38<0,"no","yes")
I don't know if the following would work.
=IF((A1-B1)<0,"no","yes")
Try it and see.
Lewis
Posted by Aladin Akyurek on November 25, 2001 11:02 AM
Care to give some examples along with expected results?
