View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sander Sander is offline
external usenet poster
 
Posts: 5
Default IF statement syntax

What is the proper syntax for a non-nested, two-condition IF statement?

Example: IF(C16<1 & C151,-B15).

This syntax appears to work when the two elements of the condition are
simultaneously true. Unfortunately, -B15 is apparently always returned, even
when the two conditions are not simultaneously true. What up? How do I get
this right?

Thanks.