If Statement Calculation

Brick

New Member
Joined
Jun 12, 2002
Messages
17
Is there a way to make an IF statement perform a calculation if a certain word is input into a cell? For example in cell E4 if YES is input then cell F4 performs a calculation, like C4*D4.

Any suggestions?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
On 2002-09-15 12:33, Brick wrote:

Is there a way to make an IF statement perform a calculation if a certain word is input into a cell? For example in cell E4 if YES is input then cell F4 performs a calculation, like C4*D4.

Any suggestions?

In F4 enter:

=IF(E4="Yes",C4*D4,"")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,727
Messages
5,573,853
Members
412,554
Latest member
faridr
Top