Forum Discussion

FreePilot's avatar
FreePilot
Copper Contributor
Jan 08, 2023

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" ¦....
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 08, 2023

FreePilot 

 

Assuming I understood, what about?

=IFS(
    AND(C25 > 3000,  C21 > 5), "green",
    OR(C25  >= 1000, C21 > 3), "blue",
    OR(C25  >= 500,  C21 > 1), "red",
    TRUE, "pink"
)

 

FreePilot's avatar
FreePilot
Copper Contributor
Jan 08, 2023

Lorenzo

 

I'll try it.  Thank you.  I've been trying for months.  I'll let you know ASAP. 

Resources