C1 = A1-A2 if A1 is less than A2 - in Excel

Question

How would I write this in Excel formula?

C1 = A1-A2 if A1 is less than A2.

Answer 1

The formula for the C1 cell should look like this:

=if(A1<A2, A1-A2, 0)

The third value in the 'if' statement (in this case, a zero) is the value that is returned if the condition is not met. In general terms, the syntax is this: =if(condition, value if true, value if false).

Answer 2

Here the value in C1 is as follws:

=IF(A1<A2, A1-A2, 0)

The third value in the 'IF' statement (here 0) is the value that is returned if the condition is not met. Thus the Syntax would be: "=IF(Condition, Value if true, Value if false)".

You can get these formulas & their synatx, if you type "SHIFT+F3", & then the relevant formula is choosen.