Thread: I need a formula: " If this cell is blank, then 0"
View Single Post
  #5   Report Post  
Aladin Akyurek
 
Posts: n/a
Default I need a formula: " If this cell is blank, then 0"
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!!!
Reply With QuoteReply With Quote