Can anyone identify the error please?

[excelos]

Hello!


I have some problem with this function that I don't know how to solve.

[]=IFERROR(IF(C22>0,$C$6,C22/IF(ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47)>0,ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47),0))-C22/IF(ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47)>0,ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47),0),0)[]

When C22 is zero, it should spit out
[]C22/IF(ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47)>0,ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47),0)[]
minus
[]C22/IF(ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47)>0,ROUNDUP(DAYS($I$6,$H$6)/7,0)-COLUMNS($D47:D47),0)[]
which should equal to zero.

However, it gives me a number!

Can anyone identify the error please?

Thanks!

 

[Special-K99]

Try entering it as an array formula?

 

[excelos]

Try entering it as an array formula?

But it's not an array formula, is it?