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