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
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
