Concatenate ++++

[Potholes]

Good evening all

I have tasked to create a database using Excel.

The problem I have encounted is.

In cell W2 a formular will produce a figure between 1 to 31

Let's say that cell W2 has produced a number 28

In Cell B2 I have the following formular

=if(W2="","Yes",concatenate("Due in",W2," Days)

What my formular in B2 is returning

Due in 28.123542562 days

What I need to do is have

Due in 28 days



Any help solving this would be appreciated.


Peter

[cyiangou]

=if(W2="","Yes",concatenate("Due in",TEXT(W2,"#0")," Days)

[Jacc]

What you have there is probably date and time. If you want to get rid of it try:

This will round it up or down.

Please Login or Register  to view this content.

This will just remove the decimals.

Please Login or Register  to view this content.

[Tony Valko]

Try it like this...

=IF(W2="","Yes","Due in "&INT(W2)&" Day"&IF(W2<>1,"s",""))

I've also added a test so that you won't get a result like:

Due in 1 days ...

Due in 1 day ...