Thread
:
I need a formula: " If this cell is blank, then 0"
View Single Post
#
6
Sandy Mann
Posts: n/a
I need a formula: " If this cell is blank, then 0"
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
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"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 Quote