1.

=(ISTEXT(G3))*(G34*0.15)

2.

=IF(ISTEXT(G3),G34*0.15,0)

Duke wrote:
I need a formula that does this:

IF CELL G3 HAS TEXT OF ANY KIND, THEN G34*.15, IF G3 IS BLANK, THEN 0.

Help!!!

"Aladin Akyurek" wrote in message
...
1.

=(ISTEXT(G3))*(G34*0.15)

2.

=IF(ISTEXT(G3),G34*0.15,0)

"Sandy Mann" wrote in message
...
If you mean text in G1 but ignore numbers and errors then try
=(ISTEXT(G3))*G34*0.15

If you mean any entry in G1 the try:

=(G3<"")*G34*0.15

mmmm....

Going to have to spend less time reading off line..... <g

Sandy