if function?

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

What is the if function to only have the formula work if there is something
in the cell.
tia
 
Do you mean...

=IF(A1="","",your formula)

=IF(ISBLANK(A1),"",your formula)
 
this should help explain if
=IF(A1<>"","This is True because there is a value in cell A1","This is False
because there is no value in cell A1")
 
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

IF function says too many nested 1
Set non-continuous PrintArea via Function / Name 0
IF AND Nested Functions - Formula Not Working 0
Can UDF return a customized hyperlink? 3
want to track time while paste value in multiple column of same roe 1
formula will not show value 4
Excel VBA 1
Advanvnce formula and function 1

Back
Top