Skip to main content
Solved

Variable Style IIF Expression

B
Jr Varsity II
Forum|alt.badge.img

I have a slightly weird question.

Can I have multiple IIF expressions within one field?

 

It seems possible, but I am not sure how to accomplish this.

 

I would like to change the cell style based on the text inside of it.

 

But the system does not like me adding another IIF statement within my expression.

 

This is what I have right now to keep it simple, but once I can get it to work, I will add a couple more colors.

 

=IIf( [InventoryItem.PreferredVendorID]='100045', 'purple20', 'default') OR

IIf( [InventoryItem.PreferredVendorID]='100351', 'yellow20',' default') 

 

 

The System doesn’t like my OR placement, does anyone know a better way to do this?

Best answer by davidnavasardyan

Hi ​@bodiec 

You can absolutely use multiple IIf statements, but you’ll need to nest them properly—no OR between them. Try this structure instead:

=IIf([InventoryItem.PreferredVendorID]='100045', 'purple20', 
 IIf([InventoryItem.PreferredVendorID]='100351', 'yellow20', 
 'default'))

Just keep stacking them like that if you need more conditions. It’s basically like a fancy "else if" chain.

View original
S
1 person likes this
  • S
    spatel79
Did this topic help you find an answer to your question?

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 605 replies
  • April 15, 2025

Hi ​@bodiec ,

You can nest the IIf statements, but easiest is to use Switch instead, something like this:

=switch( [InventoryItem.PreferredVendorID]='100045', 'purple20',  [InventoryItem.PreferredVendorID]='100351', 'yellow20', 1=1, 'default') 

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
B
A
3 people like this
  • Chris Hackett
    Chris Hackett
  • B
    bodiec
  • A
    adaughenbaugh95
davidnavasardyan
Jr Varsity I
Forum|alt.badge.img+3

Hi ​@bodiec 

You can absolutely use multiple IIf statements, but you’ll need to nest them properly—no OR between them. Try this structure instead:

=IIf([InventoryItem.PreferredVendorID]='100045', 'purple20', 
 IIf([InventoryItem.PreferredVendorID]='100351', 'yellow20', 
 'default'))

Just keep stacking them like that if you need more conditions. It’s basically like a fancy "else if" chain.

Software Engineer | Acumatica ERP Developer at ACUPOWER LTD
Chris Hackett
valentynbeznosiuk
harutyungevorgyan
6 people like this
  • Chris Hackett
    Chris Hackett
  • valentynbeznosiuk
    valentynbeznosiuk
  • harutyungevorgyan
    harutyungevorgyan
  • rimamanaseryan16
    rimamanaseryan16
  • B
    bodiec
  • A
    adaughenbaugh95
B
Jr Varsity II
Forum|alt.badge.img
  • bodiec
  • Author
  • Jr Varsity II
  • 35 replies
  • April 15, 2025

Thank you both very much!

​@davidnavasardyan ​@lauraj46 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved