=and formulas with =if formulas

[Guest]

i am attempting to create a formula that looks at one cell and if it is >0
then use the > of that cell or the sum of two other cells and if the original
cell is <0 enter 0.

 

[Ragdyer]

Try this:

=(A1>0)*MAX(A1,B1+B2)

 

[Ragdyer]

I assumed <0 *and* 0 were equal!

If they're not, try this:

=(A1>=0)*MAX(A1,B1+B2)