Date formula based on column

[srizki]

I am trying to write a formula that works like this.
In column A, I have months, starting from February ending in August
In column B, I will put an amount. If I put 600, it should fill automatically in March 500, April 400, May 300, June 200, July 100, August 0, it should be 100 less than prior month. If I put $500 in February, it will be 0 in July, therefore August should not show, so the presence of month depends on if last month’s amount is >0, otherwise “”.
Lets say A6 has February, A7 will have =IF(B6>0,EOMONTH(A6,1)””), this formula is not working, either the formula is wrong or I have to install Analyis toolPak.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks

 

[LxQ]

=IF(B6>0,EOMONTH(A6,1)””)

just need a comma: =IF(B6>0,EOMONTH(A6,1),””)

and maybe the quotation marks aren't the right ones...

 

[texasalynn]

EOMONTH is part of the analysis tool-pak

 

[srizki]

I thought so, because formula seems fine to me, as LxQ says to add comma, I did that as well, now I need to install add-in
Thanks

 

[Norie]

You might get away without the add-in.

=IF(B6>0, DATE(YEAR(A6), MONTH(A6)+1,1), "")

 

[srizki]

Thank you Norie,

 

[srizki]

The formula works fine, except when there is nothing in column B that is, it is blank but has formula =IF(B8>100,B8-100,"")
the formula in A10 gives #VALUE error, how can I adjust this formula to avoid the error.

Thanks

 

[texasalynn]

=IF(and(b8<>"",B8>100),B8-100,"")