This three IF formulas in the below all work correctly when separated from the others but when combined Excel simply says the formula contains an error. I can't work out what's causing the issue?
=IF($CJ5=0,,IF($CJ5/30<1,((30-$CJ5)*($CG5*'Revenue Forecast Weightings'!$C$4),IF($CJ5/30<2,$H5*'Revenue Forecast Weightings'!$C$4+((60-$CJ5)*$CG5*'Revenue Forecast Weightings'!$C$5),IF($CJ5/30<3,$H5*'Revenue Forecast Weightings'!$C$4+$H5*'Revenue Forecast Weightings'!$C$5+((90-$CJ5)*$CG5*'Revenue Forecast Weightings'!$C$6,)))
Thanks in advance.
=IF($CJ5=0,,IF($CJ5/30<1,((30-$CJ5)*($CG5*'Revenue Forecast Weightings'!$C$4),IF($CJ5/30<2,$H5*'Revenue Forecast Weightings'!$C$4+((60-$CJ5)*$CG5*'Revenue Forecast Weightings'!$C$5),IF($CJ5/30<3,$H5*'Revenue Forecast Weightings'!$C$4+$H5*'Revenue Forecast Weightings'!$C$5+((90-$CJ5)*$CG5*'Revenue Forecast Weightings'!$C$6,)))
Thanks in advance.