Hi, My knowledge of excel is quite basic so would appreciate any help.

I am creating a spreadsheet and if i have a negative number i want to put in a column with a formula that will come up with a 'P' (for pay)and if positive then a 'c' (for credit).

THanks,


EggHeadCafe - Software Developer Portal of Choice
HANDLING BINARY AND TEXT DATA IN XML OVER THE WIRE
http://www.eggheadcafe.com/tutorials...-and-text.aspx