If Statement Calculation

[Brick]

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?

 

[Aladin Akyurek]

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,"")