Hi please see my if statement below:
=IF('monthly cover'!K3="January",'broker summary'!B12*-1,IF('monthly cover'!K3="February",'broker summary'!C12*-1,IF('monthly cover'!K3="March",'broker summary'!D12*-1,IF('monthly cover'!K3="April",'broker summary'!E12*-1,IF('monthly cover'!K3="May",'broker summary'!F12*-1,IF('monthly cover'!K3="June",'broker summary'!G12*-1,IF('monthly cover'!K3="July",'broker summary'!H12*-1,IF('monthly cover'!K3="August",'broker summary'!I12*-1,"0"))))))))
Is there any way to continue on to the rest of the months. It will not allow me to go past the eight months, I assume.
Thank you for the assistance.
Neil
=IF('monthly cover'!K3="January",'broker summary'!B12*-1,IF('monthly cover'!K3="February",'broker summary'!C12*-1,IF('monthly cover'!K3="March",'broker summary'!D12*-1,IF('monthly cover'!K3="April",'broker summary'!E12*-1,IF('monthly cover'!K3="May",'broker summary'!F12*-1,IF('monthly cover'!K3="June",'broker summary'!G12*-1,IF('monthly cover'!K3="July",'broker summary'!H12*-1,IF('monthly cover'!K3="August",'broker summary'!I12*-1,"0"))))))))
Is there any way to continue on to the rest of the months. It will not allow me to go past the eight months, I assume.
Thank you for the assistance.
Neil