If statement

[yes_and_no]

I tried a combination ("IF" plus "and") function as

- if(Width<49", "H4", "H6") and

- if (Width>73", "H8","_").

As easily guessed, they are in conflict.

My wish is having 3 intervals (<49"), (49"÷73"), (>73") report either "H4", "H6" or "H8".

Can you help ?

[ToanDN]

if (Width<49", "H4", if (Width>73", "H8", "H6"))

[barthbradley]

if(Width < 43', "H4", if(Width > 73', "H8", "H6"))

[handjonathan]

Hi @yes_and_no 

Thanks a lot for posting your question to the forums!   Have the solutions suggested by @ToanDN @barthbradley helped with your issue?
 
We look forward to hearing back from you with more information so we can help you as a community!