View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default If formula with two conditions to meet

Sorry, I read that wrong. Try this.

IF(Z5=0,IF(AB5=3,1000,700),0)