How do you write a conditional formula in Excel?

Answer 1

This is easiest to teach while you share your screen with me following my live directions, but here goes...

First, I need to explain that Excel's conditional statements are rather messy compared to normal programming languages.

A basic IF statement using Excel's IF function would translate this English/loose code as an example:

IF cell A2 is greater than cell B2,

THEN output 1 (for True),

ELSE output 0 (for False).

In Excel, this would be written into the following function:

=IF(A2>B2, 1, 0)

because a basic IF statement formula in Excel is

=IF([logical statement], [output if true], [output if false])

Please contact me with any questions or to schedule a live, online lesson.

Thanks!

Answer 2

=IF ( condition, value if true, value if false)