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
|