Hi,

Original formula:
=IF($C4>=I$3,"",IF(H4="",((I$3-$C4+1)/I$1*$G4),IF($B4-SUM($H4:H4)>$G4,$G4,$B4-SUM($H4:H4))))

Changed to take out the blank colunm - No result
=IF($C4>=H$3,"",(H$3-$C4+1)/H$1*$G4),IF($B4-SUM($H4:H4)<$G4,$G4,$B4-SUM($H4:H4))

Please help to identify the error on the second formula.

I attached the example sheet.

Thank you.

Attached Files

IF formula Error.xlsx (15.3 KB, 16 views)