Yes, I understand why you did it that way.

But I am thinking it may not be .28 for J13, J14, J15 ........ and Eric may still want the numbers in column J show up in column K depending on "S" or "B".

Now, he has two versions to choose from depending on his needs.

Biff, I am not sure if it is better to use -J12 or J12*-1 in my formula. Do you see any difference? Feel free to fix up my formula if you see the need.

Thanks.

Epinn

"Biff" wrote in message ...
Is it true that J12 can be any number other than .28?
I am trying to get a cell to render a positive value or a negative
value of a certain number if another cell has one of two letters.

I read that to mean "a certain number" is specifically 0.28 which is why I
use AND.

Biff

"Epinn" wrote in message
...
Is it true that J12 can be any number other than .28? Can J12 be 0? Can
J12 be a negative number?

Assuming J12 is always 0, in K12, key in this formula:-

=IF(LEFT(C12)="B",-J12,IF(LEFT(C12)="S",J12,0))

Format K12 accordingly.

Epinn

"EG" wrote in message
...
I am trying to get a cell to render a positive value or a negative value of
a
certain number if another cell has one of two letters. i.e.:

if the value of cell J12 = .28 and the first letter of cell C12 is B, then
the value of cell K12 = (0.28).

if the value of cell J12 = .28 and the first letter of cell C12 is S, then
the value of cell K12 = 0.28.

I am stuck. Can someone shed some light?

eric