View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Kuunders
 
Posts: n/a
Default Divide Column A by Column B multiply Column C

don't know why you have "%" in "/65%"
the example would suggest that you want to divide by 65 and then multiply by
0.07

formula in column B would be =A1/65
formula in column C would be =b1*0.07
may need to format the C column to be a currency with two decimal places


--
Greetings from New Zealand
Bill K


"Stumped" wrote in message
...
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.