Thread: I need a formula: " If this cell is blank, then 0"
View Single Post
  #2   Report Post  
Alan
 
Posts: n/a
Default I need a formula: " If this cell is blank, then 0"
=IF(G3<0,G34*1.5,0)
Regards,
Alan.
"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!!!


Reply With QuoteReply With Quote