Less than Equal to?

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

K

Good day how would I code this?

If WALL is Equal to or greater than 0.065 and is equal to or less than
0.125 then PERCENTOD = .17

Your help is appreciated.
Thanks.
 
K said:
Good day how would I code this?

If WALL is Equal to or greater than 0.065 and is equal to or less than
0.125 then PERCENTOD = .17
Click to expand...


If WALL >= 0.065 And WALL <= 0.125 Then
PERCENTOD = .17
End If
 
Or in a query design grid --
PERCENTOD: IIf([WALL] >= 0.065 And [WALL] <= 0.125, .17, "Unknown")
 

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

Excel Need Countifs Formula Help 0
Alt codes 4
Change tax, but leave old records alone 3
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
vba macro that allows insertion of symbols at cursor 0
Multiple logic tests 0
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
conditional formula 2

Back
Top