text in formulas

steph · Feb 20th, 2002, 08:00 AM

i need to put a formula in a text string or put text in a formula.

example
60 books = (15 Blue @ $1,125 = $16,875)
(45 Red @ $1,350 = $60,750)
75% of $108,000 = $80,325

I can rearrange the text however it needs to be, but I need text and formulas in one cell.

Mark W. · Feb 20th, 2002, 08:07 AM

Quote:

On 2002-02-20 07:00, steph wrote:
i need to put a formula in a text string or put text in a formula.

example
60 books = (15 Blue @ $1,125 = $16,875)
(45 Red @ $1,350 = $60,750)
75% of $108,000 = $80,325

I can rearrange the text however it needs to be, but I need text and formulas in one cell.

What does this formula do?

[ This Message was edited by: Mark W. on 2002-02-20 07:08 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 08:00 AM	#1
steph New Member Join Date: Feb 2002 Posts: 2	i need to put a formula in a text string or put text in a formula. example 60 books = (15 Blue @ $1,125 = $16,875) (45 Red @ $1,350 = $60,750) 75% of $108,000 = $80,325 I can rearrange the text however it needs to be, but I need text and formulas in one cell.