View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default multiple IF statements

This should work...
=IF(MOD(J9,7)=0,0,J9-IF(J9<=7,0,D21))


I believe that returns 0 when J9=0, but the OP wants J9 when J9<7.


The formula is wrong for the reasons Duke pointed out, but as to your
statement... perhaps I am missing something in your statement, but isn't my
formula returning 0 when J9 equals zero the same thing as returning J9 when
J9 equals 0?

Rick