Excel 2007 : If Statement???

[jbnonn]

Trying to create a If statement, but please be kind I have little knowledge of Excel programming.

( =If (A23=if any text is input into cell, "H23*I23", "other wise do nothing")

Any help would be nice.

[ratcat]

G'day and welcome to the forum,

Copy and paste this

=IF("if any text is input into cell"=A23,H23*I23,"other wise do nothing")

Basically no quotes are needed to wrap equations just text.

HTH

RC

[jbnonn]

Trying to create a If statement, but please be kind, I have little knowledge of Excel programming.

( =If (A23=if any text is input into cell, "H23*I23", "other wise do nothing")

Any help would be nice.

The Italic text is what I need to happen, not what I want it to stay Sorry for not be more detailed.

[jeffreybrown]

How about...

=IF(ISTEXT(A23),H23*I23,"")