Adding Ceiling to IF statement

[brandybartz]

Hello:

I have a nested IF statement that I want to round up to a multiple of 7.. Since I do not have a specific cell I am referencing and is a calculation instead I am not sure where to place it in the sequence..

Current Formula
=IF(A10="x",(MAX(MIN('Market & Holidays'!$I$4,$BG10)-MAX('Market & Holidays'!$H$4,'1-5 Set'!$BD10),0))," ")

Need to add a Ceiling with a multiple of 7

 

[sheetspread]

=IF(A10="x",ceiling((MAX(MIN('Market & Holidays'!$I$4,$BG10)-MAX('Market & Holidays'!$H$4,'1-5 Set'!$BD10),0)),7)," ")

 

[brandybartz]

Works perfectly.. Thank you