Apply Number formatting to If Function within Concatenate - Office 2007
I'm trying to create an easy to use pricing spreadsheet for my employees, yet the process is anything but! For one line I have a Concatenate formula as follows:
="Easy-Pay total - 1st app $"&(IF(C2<=65.95,29.95,(C2*0.5)))&", remainder $"&C3&"/app, cc charged after each visit"
For that If function there, If a price were say, $74.95, how would I write it so that 50% of that price (false value) said 37.48 instead of 37.475? Thanks!!!
(Want everything to look good for customers when it's sent.)
I would put text([your if formula],##.##) in your formula.
EDIT: and if you want a $ add that to the $##.##
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Maybe I'm not doing it right, but still nothing. I keep getting an error.
Sorry, I was trying it using my iPad and memory, here is what I'd do...
="Easy-Pay total - 1st app $"&(text(IF(C2<=65.95,29.95,(C2*0.5))),"$00.00")&", remainder $"&C3&"/app, cc charged after each visit"
that is a better way to do it.
there, where you need use FIXED() function. E.g. ="Easy-Pay total - 1st app $"&(IF(C2<=65.95,29.95,(C2*0.5)))&", remainder $"&FIXED(C3)&"/app, cc charged after each visit"
or
="Easy-Pay total - 1st app $"&FIXED(IF(C2<=65.95,29.95,(C2*0.5)))&", remainder $"&C3&"/app, cc charged after each visit"
with no parameter it will be always 2 decimals
Applies To: Excel 2016, Excel 2010, Excel Starter, Excel 2013, Excel Online, Excel 2016 for Mac, Excel for Mac 2011, Excel 2007
Last edited by sandy666; 01-18-2016 at 08:21 PM.
In the world of excel, you sir, are a God among men - Thank You!!
If probem resolved - mark thread as solved. Thank you
I assume your complement is for sandy666's interesting approach but if it's for me I'll have to tell my wife I got a promotion.Thank you for the rep!
@Sambo kid
I assume it was for both of us
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks