I need a formula: " If this cell is blank, then 0"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
=IF(AND(ISTEXT(G3),G3<>""),G34*0.15,0)

if you by "text of any kind" mean a number as well

=IF(LEN(G3)>0,G34*0.15,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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Aladin Akyurek said:
1.

=(ISTEXT(G3))*(G34*0.15)

2.

=IF(ISTEXT(G3),G34*0.15,0)
Click to expand...

Sandy Mann said:
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
Click to expand...

mmmm....

Going to have to spend less time reading off line..... <g>

Sandy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting elements of a string cell 11
#VALUE! 4
How do I combine a VLOOKUP formula and a NETWORKDAYS formula? 2
using multiply if function 8
if statement when cell is blank 6
Formula result not displayin in cell 4
How to do COUNTIF when cells are not in a consequtive column? 4
Complex Conditional 10

Back
Top