Format to a negative value

K

kharrison

I have two columns of data. The first column contains either the text L or
P. The 2nd column is a percentage value. What I wish to do is if the first
column is L then format the percentage value to a negative. If P leave as is.

Can this be done.

Any help would be much appreciated.
 
M

Max

kharrison said:
I have two columns of data. The first column contains either the text L or
P. The 2nd column is a percentage value. What I wish to do is if the first
column is L then format the percentage value to a negative. If P leave as
Click to expand...
is.

One way ..

Assuming the 2 cols are cols A and B, data from row1 down
Put in C1: =IF(A1="","",IF(A1="L",-B1,IF(A1="P",B1,"")))
Format C1 as percentage, copy down
 
Top