View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael[_20_] Michael[_20_] is offline
external usenet poster
 
Posts: 15
Default Help with IF statement

From the documentation Excel 2000 (one I currently have
loaded) can support up to 7 nested IF statements.

To use Logical AND, OR, NOT - they are themselves
functions so you simply do AND( condition1, condition2...)

Finally an example of how you would write that same
statement is (broken up on the false condition for easier
reading):

=if(z67 < 7000, z67* 0.10,
if( and( z67<=28400,z67 =7000),((z67-7000)*0.15)+700,
if( and( z67<=68000,z67 =28400),((z67-28400)*0.25)+ 3900,
and so on...