Calculation of various Text boxes

  • Thread starter Thread starter Tempy
  • Start date Start date
T

Tempy

Hi, can somebody please help me?
I am adding up 4 text boxes, which works fine until one of
the text boxes is empty? This situation is fine as there
is not a value for that specific text box, but it must
still add up the other boxes and give a total.
 
Try something along the lines of
=Nz(Textbox1,0) + Nz(textbox2,0) + Nz(textbox3,0) +
Nz(textbox4,0)

Hope This Helps
Gerald StanleyMCSD
 
Back
Top