Thread: Trouble with IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EG EG is offline
external usenet poster
 
Posts: 38
Default Trouble with IF

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