Hi
I have a row of cells with numbers, i want to create a cell that displays OK or OD depending on whether the cell is positive or negative
im having a hard time finding out how to do this
can anyone help?
thanks
Hi
I have a row of cells with numbers, i want to create a cell that displays OK or OD depending on whether the cell is positive or negative
im having a hard time finding out how to do this
can anyone help?
thanks
Last edited by loosemember; 04-07-2011 at 03:54 AM.
Could you please upload a sample of your excel file.
Simply hit the star button to say THANK YOU.
Something like this?
=IF(A1<0,"OD","OK")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks