Formula if this than that

Occasional Visitor

I need to make a budget proposal and seem not to figure out how to make a if / than formula.

M3 (value) can't be more than N3. In this case P3 should calculate with N3. In case
M3 (value) is less than N3. P3 needs to calculate with M3.

Any suggestions how I should make this formula?

1 Reply


You may calculate with MAX(M3,N3)