LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stumped
 
Posts: n/a
Default Divide Column A by Column B multiply Column C

I do a routine spreadsheet for multiple accounts entering three basic
columns: Column A is entered with new figures daily, those figures are
divided by a percentage in Column B, which is then divided by a fraction
percentage in Column C. These figures change several times dailyin Column A,
columns B and C always remain constant, so the function needs to be attached
to the Column Alphas, not the numeric numbers since that ones changes. So I
just need the PRECISE function entries for:

Column A Column B Column C
(Any #) /65% x.07

EXAMPLE:
1,000 15.3846 $1.08

It's pretty simple, I'm not smart enough for the rhetorical reading required
for a physicist to figure it out. Just the function entry, please, and only
the function, please. Thanks so much.
 
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
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
How do I multiply a whole column by a number? cowboyeti Excel Worksheet Functions 1 July 13th 05 05:17 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
How do I multiply Column G Totals by a number and display the res. wewgyro Excel Discussion (Misc queries) 2 December 5th 04 04:27 PM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 02:15 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"