Formula help

[steve47]

Dear all

How can i add to this formula a "display contents" of another cell at the end(J24 in my excel sheet)

=1-SUMPRODUCT((Availability!$M$24:$M$500=K$6)*(Availability!$V$24:$V$500=1))

Thanks for your time

 

[gaz_chops]

Do you mean if the result of your formula = ?? then "display contents"?

 

[GlennUK]

You mean like:
=1-SUMPRODUCT((Availability!$M$24:$M$500=K$6)*(Availability!$V$24:$V$500=1))&" "&J24
?

 

[steve47]

Hi thanks for the help

Thats works fine but it displays a number 1 in front of the contents of cell J24

Is there a way of getting rid of the number 1???

 

[GlennUK]

You asked to have the contents of J24 added to the end of a formula result ... now you are asking why the formula result is in front of the contents of J24????

I think you need to explain exactly what you are after, and why.