This formula works I need some spaces

[Kurt]

I need 5 spaces after the 4" part of the formula.

The formula is working except for not having the spacing

=IF(K11=0,I11     &      "$"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

 

[6StringJazzer]

What is this formula doing different than what you want it to do? What do you mean by the 4" part of the formula? Not having what spacing?

 

[Kurt]

The test is displaying together I need 5 spaces after the first item is displayed.

 

[RoryA]

Do you mean this?

=IF(K11=0,I11&" $"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

 

[Kurt]

ADVERTISEMENT

Do you mean this?

=IF(K11=0,I11&" $"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

Hello Rory and all

Thanks for your efforts! Almost there.

I need it something like this but without displaying the " "

=IF(K11=0,I11& "     ""$"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

 

[RoryA]

I forgot that the board software strips out excessive spaces. It should have read:

=IF(K11=0,I11&"     $"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")

 

[Kurt]

ADVERTISEMENT

Hello Rory,

That worked beautifully!

Have a great day and cheers from across the Pond.

Thanks,

Kurt

 

[Kurt]

Hello Rory and all,

I need to test for one more condition.

If there is a 0 in the cell then it needs to display the same way but display the contents of column M and then the /lf at the end.

Thanks,

Kurt

 

[RoryA]

A 0 in which cell?

 

[Kurt]

Actually if there is an a number in cell K which Is lf linear feet it should display the contents of cell N.

I need to test for this additional parameter.