LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
qwopzxnm
 
Posts: n/a
Default how do i enter a function in a sentence


I'm not sure if I understand your question correctly but I'm making the
assumption that the $10,000 is the variable, and is what you want to
insert into the sentence from a cell value somewhere else.

If you have your "not to exceed" amount in cell A1.

Enter this formula:
="This quote is based on an total lump sum estimate not to exceed
"&dollar(A1,0)

This will give you a sentance that always reads the same except for the
"not to exceed" dollar amount which will change as you calculate it
differently for each individual.

Hope that helps.


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=509204

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Horrible looking IF function.... rmellison Excel Discussion (Misc queries) 3 September 12th 05 04:43 PM
creating function (vba) with range arguments Fredouille Excel Worksheet Functions 2 September 12th 05 11:01 AM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Excell should have a sentence case function like the UPPER() and . JBTaylor29 Excel Worksheet Functions 3 November 11th 04 11:54 PM


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"