Thread: Is this formula possible in Excel 2003?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Is this formula possible in Excel 2003?
Check your other post, and please do not multi-post.

Pete

On Sep 10, 1:30*am, anschutz.177
wrote:
Is this formula possible in Excel 2003?
I would like to add the cells in column "K" with the following conditions..

If I4 contains a "J" then add K4 unless L4 contains an "X"

The column "I" would contain the letter "J" or "P".
The column "L" would contain an "X" or be empty.
Column "K" would contain a currency.

Reply With QuoteReply With Quote