I want to create a formula that says 'if cell A1=0 then do this sum but if
cell A1 doesn't =0 then do a different sum.

Can this be done - if so how?!