Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |