software

hi,

i have an access database linked to an excel file. I can export data to
the excel sheet automatically out of the access.
but there are some cells where I have to fill in by myself.
there are already some formulas entered:

pictu f5.putfile.com/5/13610133422.jpg

- = minus
x = multiply

Cell *Variance*: Plan - Actual
Cell *Final Variance*: Plan - Final Actual
Cell *Revenue*: Plan x List Price
Cell *Actual Revenue*: Actual x List Price
Cell *Final Actual Rev*: Final Actual x List Price

there is a column called: spec. Price .
NOW: the column on the left List Price will be automatically filled in
with a price. It could happen that some customers get a spec price . If
so it should only calculate with the spec. price.

How do I have to write the formula in the columns quot;actual revenuequot; and
quot;final actual revenuequot; ?

Thanks--
Sale_s
------------------------------------------------------------------------
Sale_s's Profile: www.excelforum.com/member.php...oamp;userid=34558
View this thread: www.excelforum.com/showthread...hreadid=543212=IF(spec Price=quot;quot;,Actual x List Price,Actual x spec Price)

=IF(spec Price=quot;quot;,Final Actual x List Price,Final Actual x spec Price)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Sale_squot; gt; wrote in
message ...
gt;
gt; hi,
gt;
gt; i have an access database linked to an excel file. I can export data to
gt; the excel sheet automatically out of the access.
gt; but there are some cells where I have to fill in by myself.
gt; there are already some formulas entered:
gt;
gt; pictu f5.putfile.com/5/13610133422.jpg
gt;
gt; - = minus
gt; x = multiply
gt;
gt; Cell *Variance*: Plan - Actual
gt; Cell *Final Variance*: Plan - Final Actual
gt; Cell *Revenue*: Plan x List Price
gt; Cell *Actual Revenue*: Actual x List Price
gt; Cell *Final Actual Rev*: Final Actual x List Price
gt;
gt; there is a column called: spec. Price .
gt; NOW: the column on the left List Price will be automatically filled in
gt; with a price. It could happen that some customers get a spec price . If
gt; so it should only calculate with the spec. price.
gt;
gt; How do I have to write the formula in the columns quot;actual revenuequot; and
gt; quot;final actual revenuequot; ?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Sale_s
gt; ------------------------------------------------------------------------
gt; Sale_s's Profile:
www.excelforum.com/member.php...oamp;userid=34558
gt; View this thread: www.excelforum.com/showthread...hreadid=543212
gt;