If Than formula

[Steve McGuinness]

How do I create an If Than formula? For example:

If a contractor is going to paint your house, he has two methods of appling the paint 1. roller 2. spray. Each method has its on set of steps. How can I create a forumuls that will calculate the correct cells based on the application method used?

[ChemistB]

IF statements follow this general pattern
=IF(Logical statement which = true or false, if true do this, if false do this)
So
Let's say you're going to put either roller or spray in cell A1. If we use a roller, then we multiply the gallons of paint in cell A3 * 2, if we are using a roller, then we multiply the gallons of paint in A3 * 1.5.
Our Formula can read
= IF(A1 = "roller", A3* 2, A3 * 1.5)
or
=IF(A1 = "spray", A3 * 1.5, A3 *2)
Both would give the same answer.
Does that help?

[Steve McGuinness]

IF statements follow this general pattern
=IF(Logical statement which = true or false, if true do this, if false do this)
So
Let's say you're going to put either roller or spray in cell A1. If we use a roller, then we multiply the gallons of paint in cell A3 * 2, if we are using a roller, then we multiply the gallons of paint in A3 * 1.5.
Our Formula can read
= IF(A1 = "roller", A3* 2, A3 * 1.5)
or
=IF(A1 = "spray", A3 * 1.5, A3 *2)
Both would give the same answer.
Does that help?

BRILLLIANT!!! This is exactly what I wanted to know.

Thanx!!!

Steve

[Steve McGuinness]

BRILLLIANT!!! This is exactly what I wanted to know.

Thanx!

Steve

[TheExcelphile]

To learn more about the IF formula, go here.