# Putting a number in the middle of a sentence without referencing a cell

1. ## Putting a number in the middle of a sentence without referencing a cell

See the example attached. I'm trying to make it so the IF formula in A10 will simply place the COUNTIF calculation (that's currently done in B10) in the middle of the sentence without having to reference B10, as surely there's no need to essentially do the same calculation twice. So the "&\$B\$10&" part of the formula in A10 should just be the formula in B10, but I can't work out how to do this correctly.

Thanks.

2. ## Re: Putting a number in the middle of a sentence without referencing a cell

Like this:

=IF(COUNTIF(\$B\$2:\$B\$9,"Red to Green")-COUNTIF(\$B\$2:\$B\$9,"Green to Red")>=0,"Change: Red +"&(COUNTIF(\$B\$2:\$B\$9,"Red to Green")-COUNTIF(\$B\$2:\$B\$9,"Green to Red"))&" Places","Change: Red "&(COUNTIF(\$B\$2:\$B\$9,"Red to Green")-COUNTIF(\$B\$2:\$B\$9,"Green to Red"))&" Places")

3. ## Re: Putting a number in the middle of a sentence without referencing a cell

Hah, I knew it'd be something obvious I'd just missed getting right. Thanks a lot.

No problem.

5. ## Re: Putting a number in the middle of a sentence without referencing a cell

="Change: Red "&TEXT(COUNTIF(\$B\$2:\$B\$9,"Red to Green")-COUNTIF(\$B\$2:\$B\$9,"Green to Red"),"+0;-0;0")&" Places"

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1