Number Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field called Total Price wich gives me the total value of a Job. I need to subtract different fields (HARDWARE COST,STEEL COST,TOTAL LABOUR COST witch are all calculated by formulas) from the total price to get my PROFIT/LOSS.
Now my problem is that if for example there is no hardware cost my hardware cost field is empty which in turn causes my PROFIT/LOSS field to be emply even though there is still LABOUR COST and STEEL COST against that job. If there is a value in all the cost fields then the formula works.

There may be a simple solution to this but I can't figure it out.
Any suggestions would be greatly appreciated.
Thanks Shawn
 
I have a field called Total Price wich gives me the total value of a Job. I need to subtract different fields (HARDWARE COST,STEEL COST,TOTAL LABOUR COST witch are all calculated by formulas) from the total price to get my PROFIT/LOSS.
Now my problem is that if for example there is no hardware cost my hardware cost field is empty which in turn causes my PROFIT/LOSS field to be emply even though there is still LABOUR COST and STEEL COST against that job. If there is a value in all the cost fields then the formula works.

There may be a simple solution to this but I can't figure it out.
Any suggestions would be greatly appreciated.
Thanks Shawn
Click to expand...

Look up the Nz function in the VBA help files.

=Nz([FieldA]) + Nx(FieldB) - Nz(FieldC]) + etc.)
 
Back
Top