View Single Post
  #7   Report Post  
Sandy Mann
 
Posts: n/a
Default I need a formula: " If this cell is blank, then 0"

"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