Excel Formula (If/Then)
 

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 http://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 "actual revenue" and
"final actual revenue" ?

Thanks


--
Sale_s
------------------------------------------------------------------------
Sale_s's Profile: http://www.excelforum.com/member.php...o&userid=34558
View this thread: http://www.excelforum.com/showthread...hreadid=543212

Excel Formula (If/Then)
 

=IF(spec Price="",Actual x List Price,Actual x spec Price)

=IF(spec Price="",Final Actual x List Price,Final Actual x spec Price)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Sale_s" wrote in
message ...

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 http://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 "actual revenue" and
"final actual revenue" ?

Thanks


--
Sale_s
------------------------------------------------------------------------
Sale_s's Profile:
http://www.excelforum.com/member.php...o&userid=34558
View this thread: http://www.excelforum.com/showthread...hreadid=543212