Thread: Syntax error in nested IF statement.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sander Sander is offline
external usenet poster
  
Posts: 5
Default Syntax error in nested IF statement.
For I22: =IF(J22<0,1000,IF(J220,0,I23)).

This works when J22 or < 0, but not when J22=0, when it should take I23.

Why is that? Thank you.

Reply With QuoteReply With Quote