Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula not working 2

Status
Not open for further replies.
istone

istone

IS-IT--Management
Jan 24, 2007
139
US
Hi,
Can anyone tell me why this formula is not working.

IIf(([Assets]<=1000000,18500/4), IIF(([Assets] between 1000000 and 2000000),14500/4),10500/4)

I tried to make it work but in vain.
thanks in advance
 
Sort by date Sort by votes
The IIf() function takes three arguments.
Code: 
IIf( [Assets] <= 1000000, 
     18500/4,
     IIf( [Assets] between 1000000 and 2000000,
          14500/4, 
          10500/4 
        )
   )
 
Upvote 0 Downvote

Too many opening ('s. How about...
[blue]
=IIf(Assets <= 1000000, 4625, IIf(Assets Between 1000000 and 2000000, 3625, 2625))[/blue]


Randy
 
Upvote 0 Downvote
Worked. thank you so much guys.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
492
Andrzejek
Andrzejek
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
788
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
The following is not working - can
Replies
2
Views
383
Moss100
Moss100
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
1K
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top