compare calculation to a minimum number

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))
 
R

RonaldoOneNil

=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)))
 

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

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
VBA to run all variable combinations in a calculation model and store result 6
Using the result of a IIF statement in a calculation 1
Convert True (-1) or False (0) to a calculable number (1) or (0) 9
How do I round a number in a calculation to two decimal places? 3
check first 3 characters of a cell and compare to a table 4
Access 97 - Simple Calculation 12
Query to find minimum of two fields 3

Top