I have a base price for a product. The 3 columns on the left are based on the middle column, "Discount". The Discount column uses the forumula (EX:$23): ="$"& (N27+(N27*Price!B24))& " per sq. ft."
N27 = $23.00
Price!B24 = A dropdown list range from 0% to 100%
Question: How can I get it so cell, N27 - $23 show as $23.00 per sq. ft.
I have the cells set to currency.