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.

Excel Formula

I have the cells set to currency.


use TEXT:

="$"& TEXT(N27+(N27*Price!B24),"#,##0.00") & " per sq. ft."


=TEXT(N27+(N27*Price!B24),"$#,###.00 p\e\r \sq\. ft\.")
  • What does it mean when it says, "You've entered too few arguments for this function"? I get this when I use TEXT. – AndrewH Apr 22 '20 at 19:04
  • Sorry, copied too many ) see edit – Scott Craner Apr 22 '20 at 19:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.