If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert Excel 4 formula to Excel 2003 format | The Gasell | Worksheet Functions | 3 | April 12th, 2006 05:07 PM |
Excel 97 formula doesn't work in Excel 2003 | [email protected] | General Discussion | 2 | April 4th, 2006 09:34 PM |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
EDIT FORMULA BAR in excel 2003? why not? where is it? | alnav89 | Worksheet Functions | 2 | April 26th, 2005 07:02 PM |