I need part of the value of a cell to be static and the other part to be pulled from other

I need part of the value of a cell to be static and the other part to be pulled from other cell. Here is the formula I am using:

=IF(E409="Apple Pie","1:9","")

So I would like the value 1:9 to always be 1: but the 9 to be based on the value in cell D. So if Cell D is 9.7 I want the value entered to be 1:9.7
As always thanks in advance for any help.

assuming 9.7 is in cell D1 then:

=IF(E409="Apple Pie","1:"&D1,"")

Try this:

=IF(E409="Apple Pie","1:"&TEXT(D409,"0.0"),"")

Hope this helps.

Pete

Originally Posted by Pete_UK

Try this:

=IF(E409="Apple Pie","1:"&TEXT(D409,"0.0"),"")

Hope this helps.

Pete

This works great! how would I format it if say I wanted the 9 to be static and the 1 to come from D? Probably an obvious answer but I am pretty new to this.

Try it this way:


=IF(E409="Apple Pie",TEXT(D409,"0")&":9","")

Hope this helps.

Pete

Worked perfectly, Thanks!

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete