ExcelBanter - View Single Post - multiple IF statements

Thread: multiple IF statements

View Single Post

#9

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

Or a little more compactly, this...

=IF(MOD(J9,7)=0,0,J9-D21*(J97))

Rick

Reply With Quote

Reply With Quote

Rick Rothstein \(MVP - VB\)

View Public Profile

Find all posts by Rick Rothstein \(MVP - VB\)