IIf

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

kevcar40

Hi,
i have a text box on an input form
i want to compare 2 textbox values then perform a calcualtion on the
result

an example of what i am trying is below

iif([text610]>[text613], [text610]/2), iff([text610]<[text613],
[text613]/2)

can i do this using a formula

thanks

kevin
 
Create a new textbox, call it txtCalc

Set the control source to:

=iif([text610]>=[text613], [text610]/2, [text613]/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

Iff statement to show pictures 4
Need Help with an IF statement 3
nesting IIF Statement 5
Multiple iif challenge 2
iif statement 5
Need help writing a workable formula in form design...... 7
IIF Syntax error 4
Count Function 6

Back
Top