98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-course - Calculations or Formulas
excel-training-course - Calculations or Formulas
Resolved · Low Priority · Version Standard
Thu 24 Jan 2008, 19:31Delegate Stephen said...
Stephen has attended:
Project Intro Intermediate course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Calculations or Formulas
I'm creating a calculation row for calculating a price.
A1 contains width of product, B1 contains Height of product,
C1 contains Weight ( calculated by A1*B1*8.15) which is kg rate. D1 contains a rate which will be *C1 , E1 will contain the formula I require, but I need to add a process rate of say 200 but I only want this shown once C1 is calculated.
Example: A1*B1*D1+200
So in cell E1 my result will show but only when C1 is calculated.
At the moment 200 shows all the time ?
Please help
Fri 25 Jan 2008, 11:02Delegate Paul said...
RE: Calculations or Formulas
basically you want cell E1 to remain blank until data is entered into A1 and/or B1?
something like this, typed in cell E1 may help:
=if(isblank(A1),"",A1*B1*D1+200)
this will tell the cell to display nothing, unless there is data in cell A1. Once there is data in cell A1, cell E1 will then calculate itself.
Hope this helps.
Paul
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Some examples of CTRL key shortcuts in Excel 2010Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version? |
