=and formulas with =if formulas

S

spicole

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.
 
R

Ragdyer

I assumed <0 *and* 0 were equal!

If they're not, try this:

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