Thread: Formula question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Formula question
If column A will contain ONLY a B or an S, you can write this IF
function:
=IF(A1="b",C1-B1,B1-C1)

Reply With QuoteReply With Quote