Thread: How do I complete this nested if formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bobbybee Bobbybee is offline
external usenet poster
  
Posts: 2
Default How do I complete this nested if formula
This formula is working for the condition "If Long" but how do I add "If
Short" in a nested formula thats checks both criteria?

=IF(AND(B3="Long",H3<E3-G3),"NO GOOD","GOOD")
Reply With QuoteReply With Quote