I can't seem to make my IF/AND formula work

I want to show a figure of 48000 in a cell when the Total Biogas Actual m3 cell on the row is greater than 0 and the LG cell on the row states Local Generation:

=IF(AND([Total Biogas Actual m3]1= >0, [LG]1= Local Generation), "48000", "0")

I've tried several different ways but all I get is #UNPARSEABLE or #INCORRECTARGUMENT

Can anyone help please?


Linzi :-)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!