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)

You have a circular reference in H4.

Thank you xor. Can you help to make the second formula to work please?

Please explain in words what you want and show the results expected.

Dear Xor,
It will be easier if you don't mind to open up my example sheet attached.
In the first tab, the formula worked perfectly with the right result.
In the second tab, when I took out the blank column and changed the formula. The result failed.
It maybe a bit hard to put this into words.
Really appreciate your help.
Thank you

Can't you just hide column H in Sheet1?

Maybe I have to do that then. Thank you.