View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default I need a formula: " If this cell is blank, then 0"

=IF(AND(ISTEXT(G3),G3<""),G34*0.15,0)

if you by "text of any kind" mean a number as well

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


--

Regards,

Peo Sjoblom

"Duke" wrote in message
...
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!!!