# This formula works I need some spaces

#### Kurt

##### Well-known Member
I need 5 spaces after the 4" part of the formula.

The formula is working except for not having the spacing

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

Last edited:

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### 6StringJazzer

##### Well-known Member
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

##### Well-known Member
The test is displaying together I need 5 spaces after the first item is displayed.

#### RoryA

##### MrExcel MVP, Moderator
Do you mean this?

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

#### Kurt

##### Well-known Member
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 " "

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

#### RoryA

##### MrExcel MVP, Moderator
I forgot that the board software strips out excessive spaces. It should have read:

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

#### Kurt

##### Well-known Member
Hello Rory,

That worked beautifully!

Have a great day and cheers from across the Pond.

Thanks,

Kurt

#### Kurt

##### Well-known Member
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

##### MrExcel MVP, Moderator
A 0 in which cell?

#### Kurt

##### Well-known Member
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.

Replies
6
Views
205
Replies
0
Views
157
Replies
9
Views
133
Replies
20
Views
460
Replies
5
Views
156

1,195,961
Messages
6,012,573
Members
441,712
Latest member
MartinGM

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back