View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PSmith PSmith is offline
external usenet poster
 
Posts: 14
Default Conditional formula based on 2 pre-conditions

Can anyone tell me what is wrong with the following formula? I only want the
division part of the formula to be executed if the previous two conditions
are both satisfied, if either one isn't satisfied, then I'd like it to return
the "--" value but I can't seem to get the parentheses right. Many thanks.

=IF(D57<"NA"& IF(D220,D22/D57,"--"))