View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How do I complete this nested if formula

Depends on how you want it nested, but my guess is:
=IF(AND(OR(B3="Long",B3="Short"),H3<E3-G3),"NO GOOD","GOOD")

If B3 equals "Long" or "Short, and H3<E3-G3, then cell displays "no good".
If either condition is false, returns "good".
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bobbybee" wrote:

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")