Thread: if + if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WLMPilot WLMPilot is offline
external usenet poster
  
Posts: 470
Default if + if
=IF(OR(D1<x, D15<x),0,xxxxxxxx) -- where xxxxxxxx is the criteria if
either cell does equal x.

Les



"Laure" wrote:

How do I formulate if cell d1 = x and cell d15 = x then use my formula but if
either cell does not = x then use 0 (zero)
Reply With QuoteReply With Quote