if function?
 

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

if function?
 

=if(a1="","",a1*4)
--
Don Guillett
SalesAid Software

"Phil" wrote in message
...
What is the if function to only have the formula work if there is
something in the cell.
tia

if function?
 

Do you mean...

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

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


"Phil" wrote:

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

if function?
 

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")

"Phil" wrote:

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