excel-training-course - calculations formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-course - Calculations or Formulas

excel-training-course - Calculations or Formulas

resolvedResolved · Low Priority · Version Standard

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

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Server loaded in 0.08 secs.