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

 

[RoryA]

Isn't that just replacing AH11 with N11?

 

[Kurt]

Isn't that just replacing AH11 with N11?

Yes exactly and then it displays with the price and /lf at the end.

 

[RoryA]

I mean just replacing the last AH11 with N11 in the formula as I last posted it.

 

[Kurt]

I mean just replacing the last AH11 with N11 in the formula as I last posted it.

Yes so if there is an amount $11.11/Qty and the second condition is met for testing for linear ft then it would show another dollar amount say $22.22/lf or whatever that dollar amount is.

 

[RoryA]

I'm not following you at all I'm afraid. What precisely are the two conditions?

 

[Kurt]

If column K has an amount in it which is linear feet lf then I need to add that condition and display the total like 4" 22.22/lf

I just need to add this parameter to this formula.

I apologize for any confusion.

 

[RoryA]

Your formula already tests column K, so I'm not clear on how that is an additional condition?

 

[Kurt]

If column K is not 0 then it displays the amount in column K like this 6' 22.22/lf

 

[RoryA]

And what should it display?

 

[Kurt]

And what should it display?

Something like 4" $222.22/lf instead of 4" $222.22/Qty