software

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.

gt; Column A Column B Column C
gt; (Any #) /65% x.07
gt; 1,000 15.3846 $1.08

Assume data in col A starts in A2 down,
and we have:

In B1: 65
In C1: 0.07

then we could put

in B2: =IF(A2=quot;quot;,quot;quot;,A2/B$1)
in C2: =IF(B2=quot;quot;,quot;quot;,B2*C$1)

Select B2:C2, copy down as far as required
Format col C as currency
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Stumpedquot; gt; wrote in message
...
gt; I do a routine spreadsheet for multiple accounts entering three basic
gt; columns: Column A is entered with new figures daily, those figures are
gt; divided by a percentage in Column B, which is then divided by a fraction
gt; percentage in Column C. These figures change several times dailyin Column
A,
gt; columns B and C always remain constant, so the function needs to be
attached
gt; to the Column Alphas, not the numeric numbers since that ones changes. So
I
gt; just need the PRECISE function entries for:
gt;
gt; Column A Column B Column C
gt; (Any #) /65% x.07
gt;
gt; EXAMPLE:
gt; 1,000 15.3846 $1.08
gt;
gt; It's pretty simple, I'm not smart enough for the rhetorical reading
required
gt; for a physicist to figure it out. Just the function entry, please, and
only
gt; the function, please. Thanks so much.
don't know why you have quot;%quot; in quot;/65%quot;
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 Kquot;Stumpedquot; gt; wrote in message
...
gt;I do a routine spreadsheet for multiple accounts entering three basic
gt; columns: Column A is entered with new figures daily, those figures are
gt; divided by a percentage in Column B, which is then divided by a fraction
gt; percentage in Column C. These figures change several times dailyin Column
gt; A,
gt; columns B and C always remain constant, so the function needs to be
gt; attached
gt; to the Column Alphas, not the numeric numbers since that ones changes. So
gt; I
gt; just need the PRECISE function entries for:
gt;
gt; Column A Column B Column C
gt; (Any #) /65% x.07
gt;
gt; EXAMPLE:
gt; 1,000 15.3846 $1.08
gt;
gt; It's pretty simple, I'm not smart enough for the rhetorical reading
gt; required
gt; for a physicist to figure it out. Just the function entry, please, and
gt; only
gt; the function, please. Thanks so much.
The advantage of having the formulas in cols B and C point to quot;fixedquot; cells
(i.e. B1 and C1), instead of hardcoding the values: 65 and 0.07 directly
into the formulas, is that we don't have to amend all the formulas should
the values(constants) need to be changed in future. We'd just simply change
the values in B1 and C1.
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--