I am receiving invalid syntax for my formula. A1, A2, and txtAmount is the name of the text box, and they are general numbers.
I need to (A1*A2,"",Round(txtAmount*1200/A1/A2/0,0))
=Nz(Nz([A1,0],0)Nz([A2],0),"",Round(Nz(txtAmount],0)Nz(1200)/Nz([A1,0],0)Nz([A2],0))
Thank you