View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Nested IF with OR Function

Hi Trudy

Something like
=IF(OR(A10,A20),"",B1+B2)

Regards

Roger Govier


Trudy wrote:
How do I accomplish this:
If a cell value 0 OR another cell value 0, then leave blank. If either
contains a value, then calculate.