Excel question

[tamsyn cross]

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/tutorial...71-c05dd05ba1fd/handling-binary-and-text.aspx

 

[tamsyn cross]

Not to worry....answere my own question.

=IF(AD2<0,"P","R")

Now am looking for a formula that when it sees a P will take away the - and from the number and if it is a credit it will remain the same.

Thanks,
Tamsyn



tamsyn cross wrote:

Excel question
30-Oct-09

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,

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
PABZlib In-Memory ASP/ XML Compression Component
http://www.eggheadcafe.com/tutorial...b26-1b94d92fb6ac/pabzlib-inmemory-asp-xm.aspx

 

[Patrick Molloy]

so you have a number in lets say cell B1
the in C1 put
=IF(B1<=0,"P","C")

This says if the value in b1 is less than or equal to zero, use the letter
"P" otherwise use the letter "C")

Now assuming B1 is the top of a column you now need to replicate the formula
down, to do this, select the cell with the formula, C1. Hover the mouse over
the bottom right hand corner until it becomes a black cross, then double
click to automatically replicate the formula down the column.

 

[Scoops]

Not to worry....answere my own question.

=IF(AD2<0,"P","R")

Now am looking for a formula that when it sees a P will take away the - and from the number and if it is a credit it will remain the same.

Thanks,
Tamsyn

tamsyn cross wrote:

Excel question
30-Oct-09

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,

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
PABZlib In-Memory ASP/ XML Compression Componenthttp://www.eggheadcafe.com/tutorials/aspnet/af07211b-a0c2-45df-ab26-1...

Have a look at ABS, eg

=ABS(D2)

Regards

Steve