Column A Column B Column C
(Any #) /65% x.07
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="","",A2/B$1)
in C2: =IF(B2="","",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
http://savefile.com/projects/236895
--
"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.