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.
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.