Forum Discussion
FreePilot
Jan 08, 2023Copper Contributor
If functions with but and or nested
I need help. this is my problem... If C25>3000 and C21>5 then put "green" but if C25>=1000 and/or C21>3 then put "blue" but if C25>=500 and/or C21>1 then put "red" if not then put "pink" ¦....
Riny_van_Eekelen
Jan 08, 2023Platinum Contributor
FreePilot There's technically nothing wrong with your formula, though you probably applied an incorrect logic to the different IF statements.
Please give an example of a wrong result and explain why it's wrong.
- FreePilotJan 08, 2023Copper ContributorI'm very thankful for your participation in helping. I would continue to enjoy your input. To keep the conversation simple I'm going to only send my responses to LZ but please follow along. I mean my answer goes to you also.