compare calculation to a minimum number

  • Thread starter Thread starter Twatry
  • Start date Start date
T

Twatry

I have created a form to act as an invoice. I have a text box I created a
calcualtion in but I need to be able take the result of the calculation and
compare it to a minimum charge, if the result is lower than say 250 post 250
or post the result of the calculation. Here is what I have so far kn the
control source under the data tab.

=IIf([ex: postal ij package] Is Null,Null,Round(Sum([ex: postal ij
package]/1000)*2.6,2))
 
=IIf(IsNull([ex: postal ij package]),Null,IIf(Round(Sum([ex: postal ij
package]/1000)*2.6,2)<250,250,Round(Sum([ex: postal ij package]/1000)*2.6,2)))
 
Back
Top