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

 

[Kurt]

Then it should display the amount in Column L on this second condition.

 

[RoryA]

Let's start again. Please describe in words all the calculation steps the formula should take.

 

[Kurt]

Then it should display the amount in Column L on this second condition.

I got to speak with Smitty briefly.

He said I needed to test for another condition.

I am trying this but no luck so far:

=IF(K3=0,I3&"     $"&TEXT(AH3,".00")&"/Qty",AH3&"/lf",IF(K3>0,I3&"     $"&TEXT(AH3,".00")&",AH3&"/lf")

 

[Kurt]

Let's start again. Please describe in words all the calculation steps the formula should take.

I need to take column I which is Size then test to if there is a dollar amount in column AH. If there is a column amount in AH then the cell displays something like 4" $225.22/Qty
The second test is to see if there Is a number in column K which is linear feet. If there is then we need to display the amount in column N so it would look like 6" $225.22/lf

I hope this helps to clarify.

 

[Kurt]

I am trying this formula to test the second part of the condition:

[code\
=IF(K3=0,I3&" $"&TEXT(AH3,".00")&"/Qty",AH3&"/lf",IF(K3>0,I3&" $"&TEXT(AH3,".00")&",N3 & "/lf"))
[/code]

I get an error on the "/lf" part right now