Excel question

T

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
 
P

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.
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top