Thread: Change dollar amount to a negative if another colum has a "P"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marvin Marvin is offline
external usenet poster
  
Posts: 71
Default Change dollar amount to a negative if another colum has a "P"
I have numbers in a colum that I want to change to a negative(PAID) amount if
there is a "P" in the next column. I need to be able to enter numbers so I
cannot place a formula in the numbers column.
Reply With QuoteReply With Quote