Calculation of various Text boxes

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

Gerald Stanley

Try something along the lines of
=Nz(Textbox1,0) + Nz(textbox2,0) + Nz(textbox3,0) +
Nz(textbox4,0)

Hope This Helps
Gerald StanleyMCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top