Excel Formula (If/Then)

S

Sale_s

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:

picture: 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
 
B

Bob Phillips

=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)
 
Top