If Statemnts

C

coffee-girl

Hi there

i have a text box where a user will enter a value.. txtValue

then i have another text box txtTotal.. what i need is to have this txtTotal
to have something like this..

if txtValue is greater then 9 then value = 2
if txtValue is greater than 7 and less then 9 value = 3
if txtValue is great then 5 and less than 7 value = 4

can anyone help that would be great i'm going nuts over here.. Thank you..
 
H

hstoupa

I would set rules on txtValue, with conditions. So my first rule would
have the conditions that txtValue>9 and the rule itself would set
txtTotal to 2. Then my second rule would have the condition that
txtValue>7 and txtValue<9 and would set txtTotal to 3, and so on. You
will probably also need a rule that clears txtTotal if the value in
txtValue is outside of the ranges you have set conditions for.
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Paragraph numbering in Word 1
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Update a variable field from a text box value 13
Set report controls visible property depending on value 5
Adding rota 0
Link a text box based on drop down box with four options MS Word 365 0

Top